Hi, I want to compare a datatime value stored in the database with the todays date(Only todays date, not the time). I have written below expression to compare the todays date. formatDateTime($currentObject/ScheduleTime,'dd/MM/yyyy')=formatDateTime([%CurrentDateTime%],'dd/MM/yyyy') Here , the [%CurrentDateTime%] returns the date in user local time done and $currentObject/ScheduleTime return the date in UTC time zone. For this reason, the comparison is failing. Please suggest me on this. Thanks in advance
asked
Abrar Ahmed
1 answers
0
You can use formatDateTimeUTC instead, that should fix the issue.