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?
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: