Skip to main content
J
jaganc880
June 30, 2021
Question

Time Zone issue

  • June 30, 2021
  • 9 replies
  • 0 views

Hi,

I have a scenario where my Database is in GMT and I am trying to convert it to EST time by using GMT function  gmt(property(local!data,"XXX",{}),"EDT") its working fine during night time but when this function is executed during day time its giving current date-1.

Any solution for this would be really appreciated.

9 replies

C
chanakyav0002
Known Participant
June 30, 2021

When you query from database using QueryEntity the datetimes will be converted to loggedInUser default timezone. You don't have to do any convertions.

J
jaganc880Author
June 30, 2021

Thanks for your replay, 

My profile Time zone is in EST only and if I use it directly its working fine in day time but in the night time(8PM)  it adds 1 day to the current date, that is why I am converting it to EST by using this function  gmt(property(local!data,"XXX",{}),"EDT")

csteward
csteward
June 30, 2021

What the initial reply here was indicating is that, your data is in GMT in the database, you are retrieving it into local!data at which time Appian is automatically applying the EDT offset.  When you then wrap with gmt(), you are adding an additional EST offset / doubling it, pushing it 4 hours into the next day.

To troubleshoot, review a specific time in the DB, then on your interface review the value of property(local!data,"XXX",{})

Terms & ConditionsAccessibility statement