Known Participant

Solved

How are Dates formatted in Appian

11 replies
13 views

Hello,

Do you know how Appian dates are formatted?

I created a transaction at 5:01PM CDT and it appears on the database as 2022-08-12 22:01:18.070

Thanks

gopalk2865Answer

Participating Frequently

Hi, you can use text() function.

gopalk2865Answer

Participating Frequently

Hi, you can use text() function.

nicholaso0002Author

Known Participant

this worked for just outputting the date on a text file; but the date is saving using GMT on the database.Thanks

mikes0011

Brainy

but the date is saving using GMT on the database

As I said in my previous reply - this is how Appian works. You should not try to override this behavior, because many internal pieces of functionality depend on it. You need to allow Appian to handle time zone conversion and properly utilize the front-end functionality for local timestamp values.

The Expression Guru

D

deepakg681722

Inspiring

I think it takes the GMT timezone by default. Any further answers will be appreciated.

mikes0011

Brainy

Appian stores all dates in a standardized GMT-based decimal format. We don't see that decimal value (without trying really hard), instead we see the interpretation of what that value means to us. When we look in the DB, what we see is that decimal value converted back into a (GMT) timestamp value. In the Appian front-end, either at entry time or after querying the value back from the DB, we see the value in GMT converted back to our timezone.

The Expression Guru

nicholaso0002Author

Known Participant

How do we ensure that the time is not converted into GMT when saving to the Database?

mikes0011

Brainy

You don't, and you shouldn't.

The Expression Guru

Sign up

Login with SSO

Login to the community

Login with SSO