Screen DateTime issue in Reactive Web App

Hi Guys,

I've developed a new project using Reactive Web app but I have issue using the DateTime. It's showing correct in the Database/Entity but NOT in UI screen.

Saved the date with the following:

DB Entity: 14-07-2020 11:09:55

Web Screen: 14 July 2020 23:09


I used the date format to display in the screen below:

FormatDateTime(GetOfficeWorkDays.List.Current.OfficeWorkDays.CreatedDateTime, "dd MMM yyyy HH:mm")

I'm in New Zealand timezone so the DB entity is the correct datetime.

Also, I used the ConvertToNZT extension


Thanks in advance guys!

Hi TheGame,

Please try to define the provided Date_Format within the UI expression with "hh" (Lowercase -- hh) as mentioned below... I think because of the the capital 'HH' in the defined date_format, it is displaying the hour in 24 hrs format

FormatDateTime(GetOfficeWorkDays.List.Current.OfficeWorkDays.CreatedDateTime, "dd MMM yyyy hh:mm")


Hope this helps you!


Regards,

Benjith Sam