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?
Hard Coded Dates
+21Welcome 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())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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.