Parsing Constant Date doesn't work properly

[Hagar-Usama]

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 solution]

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