todate function subtracting date with day minus one day
Discussion posts and replies are publicly visible
That's a timezone issue. Please share the code.
https://appian.rocks/2023/02/13/working-with-time-in-appian/