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.
Discussion posts and replies are publicly visible
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.
The issue is not with formatting. We can format different way.
Issue is with difference in dates.
Thank you.
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).
Hi Mike,
Appian DateField with value as today() is showing as 5/5/2023.
When I saved the same value in the database, it was saving in the db also the same. 5/5/2023.
Where as, then I try to retrieve using the RecordType and show in the grid, then only it was showing like
I don't not understand, appian today() function is giving 5/5/2023 and database is also storing same value, but when try to show the same field value in the grid, it was showing 5/4/2023.
So, do I need convert date to required format ONLY while displaying or can I handle this through any setting at Appian end.
Please advise.
Thanks.
It depends on whether the data type you're saving is DATE or if it's DATETIME.
As Mike and Laurens already explained that Appian adds local timezone offset to the datetime, that's why you are seeing the difference. You can wrap the value from record in gmt() to remove the local timezone offset, try gmt() on today() also to see the difference.
gmt(local(now(), "EDT")) is returning 5/5/2023 11:06 PM EDT and this is matching with my local time.
When I ran the below code in an interface, I am getting 05/06/2023. Still not understood what is happening.
a!dateField( label: " Date", labelPosition: "ABOVE", helpTooltip: " Date", value: gmt(local(now(), "EDT")), saveInto: local!date, /*disabled: true,*/ validations: {}
Maybe this blog post helps you: appian.rocks/.../