Skip to main content
swapnar6405
swapnar6405
May 5, 2023
Question

Date difference in the screen, database vs RecordType

  • May 5, 2023
  • 8 replies
  • 0 views

Hi,

When I try to add date using Today() ,value is saving into the database properly (Refer to the below attached screen shot)

Whereas when I try to load into the grid using RecordType, it was showing like below. Any advises on this please.

8 replies

L
laurensw425805
May 5, 2023

This is default Appian behaviour for interpreting the DB value given the field type.

You may use text() to format the value to your likings.

swapnar6405
swapnar6405Author
May 5, 2023

The issue is not with formatting. We can format different way.

Issue is with difference in dates.

Thank you.

mikes0011
mikes0011
Brainy
May 5, 2023

But it's not a difference in dates, it's actually the interpretation as Laurens already pointed out.

The Appian DB stores all datetimes in GMT; when you display this info on the front end, Appian always auto-converts the GMT datetime value into the local datetime (which may or may not evaluate to the same actual date, since GMT may or may not be across the date boundary for different values).

Terms & ConditionsAccessibility statement