Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm trying to compare two dates together, and even though the dates seems to be the same when displayed in a "Text & image" chart, the IF function returns that they're not the same.
Here is what's returned inside each textbox:
Object 1 expression is:
=Today()
Object 2 expression is:
=Date(Comments_FileTime)
Object 3 expression is:
=If(Date(Comments_FileTime) = Today(), '1', '0')
What am I doing wrong here?
Thank you guys for your time,
LesJean
Hi
probably Comments_FileTime has time.
Try to use Date(Floor(Comments_FileTime))
Hi
probably Comments_FileTime has time.
Try to use Date(Floor(Comments_FileTime))
try
if(Date#( Comments_FileTime,'YYYY-MM-DD')=today(),1,0)
That was it StarinieriG, thanks a lot