Help

Re: Hard Coded Dates

426 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Claremont_Scout
4 - Data Explorer
4 - Data Explorer

Is there a way to use hard coded dates in a date calculation e.g. Date Diff(1/1/2019,Today()). I can get the right calculation if both dates are in fields but the moment put in a hard coded date it doesn’t work. Any ideas?

2 Replies 2

Welcome to the community, @Claremont_Scouts! :grinning_face_with_big_eyes: To use a literal date, you have to parse a text version of the date with DATETIME_PARSE(), which creates a datetime object to use for comparison:

DATETIME_DIFF(DATETIME_PARSE("1/1/2019"), TODAY())

Thanks. I figured this out after a bit… Nice to know I got it right and didn’t do some clumsy workaround.