Hard Coded Dates

[Claremont_Scout]

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?

[Justin_Barrett]

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())

[Claremont_Scout]

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