I am using the formula DateTimeParse to change a string of dd/mm/yyyy to yyyy-mm-dd and then the DateTimeTrim to get an eom result. The output I was getting also included 23:59:59 and so I truncated the size to 10. That, however, gives me warnings all the way down about the truncating. What I am I missing in my formulas to not show the end of the day time along with the date for eom?
Solved! Go to Solution.
Hey @ppatane the warnings are just exactly that - warnings. They're just letting you know that you're cutting off trailing parts of the string (i.e. the time part as it's a DateTime). If you want to avoid these, instead of reducing the field size to 10, I'd just change the data type to a 'Date' - this will only keep the date part and cut off the time element naturally.
Date format, of course. Thank you!