Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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 , 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
Thanks it's working with your function! Only hours should be the same, so all fine (i deleted the MM part).
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |