Hi! Does anyone know how can I fixed the next situation?
I want to get the date of a datetime using the function todate() but if the datetime is after 9PM (Chile Time), the result for the function is not the real date but the next day and this should only happens when the time is past 12 AM.
Discussion posts and replies are publicly visible
Try Using this logic
date( year(ri!DateTime),month(ri!DateTime),day(ri!DateTime) )
It didn't work :( I still getting the next day if the hour is after 9PM
todate(local(ri!DateTime,"CLT"))
romiev8844 Try this
datevalue(tostring(ri!DateTime))
Appian Uses GMT as Standard time. Try using below code and pass your respective timezone
todate(local(ri!Date,"IST"))