comparing dates is not working

(0) Share

Report

Posted on by junior AX

1,552

Hi,

Today's date is 26/10/2020 and dateTime1 is 26/10/2020

so when i say if (26/10/2020 > 26/10/2020 2 days) then it should not enter the if statement but it does in my case so how come?

if(DateTimeUtil::getSystemDateTime() > DateTimeUtil::addDays(dateTime1 ,2)
{
            info(strFmt("%1",DateTimeUtil::addDays(dateTime1,2)));
            info(strFmt("%1",DateTimeUtil::getSystemDateTime()));
}

I have the same question (0)

All responses (18)

Answers (0)

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Junior AX,

What output do you see in the infolog?

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Sergie,

could it be that it add days after comparing. I'm not sure why this is happening?

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Junior Ax,

Based on your code, it does not enter the if statement.

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Blue Wang,

Try defining dateTime1 alone and add the 2 days in the compare. Does it enter it?

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Junior,

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi BlueWang,

while select table1
where DateTimeUtil::getSystemDateTime() > DateTimeUtil::addDays(table1.DateTime ,2)
{
info(strFmt("%1",table1.DateTime));
info(strFmt("%1",DateTimeUtil::addDays(table1.DateTime ,2)));
info(strFmt("%1",DateTimeUtil::getSystemDateTime()));

}

i thought it's because the table field is allow edit and allow edit on create = false, i changed it to true but still

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi junior AX,

What is the EDT assigned to the DateTime field in the table?

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Gunjan,

no EDT, it's just utcDateTime field

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi juniorAX,

Could you please use the DateTimeUtil::applyTimeZoneOffset() to DateTime1 and use the UTC timezone. Please share the result from running the query.

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Gunjan,

can you please explain more, what does this function mean and how to use it to get my result?

Was this reply helpful? Yes No