Compare Dates only by day and hours (without minutes and seconds)

[makalikratia]

Hi everyone,

I would like to compare two dates and pay attention only to the day and the hour, minute and second should not be considered.

Example:
Date A: 02/25/2021 03:05:55
Date B: 02/25/2021 03:23:20

Compare_Dates = if Date A = Date B then 1 else 0

At the moment this results in the value 0, but should be 1

Looking forward to your help!

[amitchandak · Accepted solution]

@makalikratia , Try like

if(format([Date A] , "YYYYMMDD HH:MM") =format([Date B] , "YYYYMMDD HH:MM"),1,0)

But example dates are not equal at min level

[makalikratia]

Thanks it's working with your function! Only hours should be the same, so all fine (i deleted the MM part).