Two conditions inside dmx-bind:disabled

Wappler General
1

Hi again,
I’m stuck in this, I don’t know what I’m missing.
I’m trying to use two conditions inside dmx-bin:disabled, the variables are obtained from database.

image
image409×564 35.6 KB

The idea is;

If local date <= database date
&
local time <= database time

Something like this;
2021-09-03 <= 2021-09-04
08:00:00 <= 09:00:00

This is what I have:

dmx-bind:disabled="var2.datetime.formatDate('HH:mm:ss') <= hora.value && var2.datetime.toISODate() <= asis.value"

image
image1699×1320 334 KB

But it doesn’t works, if I use for separetly they works, but It’s necessary for me to meet these two conditions with date and time.
For example if I leave only one of these two condition it works.

bind:disabled="var2.datetime.formatDate('HH:mm:ss') <= hora.value" -----Works
bind:disabled="var2.datetime.toISODate() <= asis.value" -----Works

Before I’m was testing with only one column in database with format DATETIME, but it doesn’t works, I thought that create separate column one for date and other for time will be more easily, but not.

Thanks

2

If these work separately and both return true, then this should be working fine:

dmx-bind:disabled="(var2.datetime.formatDate('HH:mm:ss') <= hora.value) && (var2.datetime.toISODate() <= asis.value)"
3

That’s the deal, I don’t know why the conditions together won’t work.
For example, if TIME in database is less than current time it do not get deactivated, and DATE is bypassing.
image

image
image596×822 43 KB

If time in database is greater than current time it get deactivated as espected:
image

image
image613×832 47.6 KB

Problem comes with “TIME”, looks like that"TIME" it not passing TRUE when two conditions are together.
No matter what date is in database, if “DATE” es less or greater than current time it doesn’t matter.

4

Do both expressions placed on the page in {{ }} return true? Most probably one of them just does not return true.

5

Totally true, one of these condition where false, mal formed. That’s because format from database is;
2021-09-03 14:38:28
and datetime var format from wrappler is;
2021-09-03T14:38:28-05:00

So, this is wrong, using two columns in database DATE and TIME, wrong because the format using of “formatDate”, unnecesary, can be shorter.
dmx-bind:disabled="(var2.datetime.formatDate('HH:mm:ss') <= hora.value) && (var2.datetime.toISODate() <= asis.value)"

This is correct using “formatDate” using in db only one column DATETIME, ther shorter way.
dmx-bind:disabled="var1.datetime.formatDate('y-MM-dd HH:mm:ss') <= asis.value"

If anyone need to disable or change dynamic attributes using DATATIME directly from database, it’s necessary to have “Date and Time” and “Moment”, but keep in mind using your corresponding locale of moment and of course using the right “formatDate”.

-App
--Date and Time: var1
--Moment: moment1

Thanks for your great and quickly support!