1 of 1 people found this helpful
If Date1<=Date2 Then 'Fail' Else 'Pass' END
I tried this, but it only compares the dates and not the time as well. I want to compare both the date and time.
Can you attach a workbook?
I just tried a calculated field as
#12/28/2018 12:51:05 PM# = #12/28/2018 12:50:05 PM#
and it returned false which mean it considering time as well.
Hi Manesh! I figured out what my issue was. I would like to ask, is there any way you can compare certain parts of a datetime? Lets say for example if I wanted to compare MM/dd/YYYY HH24 but not the minutes, how would i create a calculation to exclude the minutes?
DATETRUNC('hour',[Date Field]) should truncate the date field to hour.