Skip to main content
swapnar6405
Known Participant
May 5, 2023 2:11 PM UTC
Question

Date difference in the screen, database vs RecordType

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

Participating Frequently
May 5, 2023 2:17 PM UTC

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
Known Participant
May 5, 2023 2:59 PM UTC

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

Issue is with difference in dates.

Thank you.

mikes0011
Brainy
May 5, 2023 3:43 PM UTC

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).

The Expression Guru