Parsing Constant Date doesn't work properly

Question

Hello,

I am attempting to assign a constant date to use in my model, but I am encountering an issue where the time is not being parsed correctly. I have attempted to use DateTimeParse, however it appears to be rejecting the constant as a numeric value rather than a string.

How can I fix this?

Thanks!

alexnajm · Accepted Answer

I would uncheck the # column for the user constant - we wouldn't want to store the string as a number since there are hyphens!

Edit: I tested this on my side and it works perfectly. I might also retype as 2022-05-23