DateTime property time zone issue

User Experience
,
1

DateTime property time zone issue

When I use DateTime type property to start date or date / time, found it’s stored in clipboard as GMT time, e.g. user input date 20230805, then it’s stored as 20230804 16:00 GMT. (we are in GMT+8 time zone) so it equal to local time 20230805 00:00.

Later if we want to get day of this date, we use function like @date, then we get 4 instead of 5.

Any solution for this? Thanks.

2

@MaxonL16591286

Did you tried the formatdatetime() function . It takes time zone as a parameters also. You can pass the time zone you need and check if it is returning the expected date time value or not