HunnyVinod_Kuma

8 months agoQrew Member

# Comparing time value with current time value using Now() function

I want to compare the time value currently we have in our data with the current time value and I'm using Now() function for this but due to seconds difference it is not able to compare. For example: if we have the date time value as 12/21/23 3:30PM and I want to check if current time is equal to 12/21/23 3:30PM (Now()= 12/21/23 3:30PM) then return true else false but due to seconds value it is giving incorrect result/false.

Any suggestions to solve this?

Regards,

Hunny

------------------------------

Hunny Vinod Kumar

------------------------------