I am storing some dates from UI and some using now() function in process model.

vipins over 9 years ago

I am storing some dates from UI and some using now() function in process model. Below is step by step change in them.

In UI (in EST/EDT Timezone):
Date1 (entered from screen) : 10/14/2015 (NO TIMESTAMP only Date)

In Process Model (TIMEZONE: EST5EDT):
Date1 = 10/13/2015 8:00:00 PM
Date2 (storing in script task using function now()) = 10/25/2015 08:47:53 AM (matching correct from EDT time)

In DB:
Date1 = 10/14/2015 12:00:00 AM
Date2 = 10/26/2015 12:47:53 AM

While fetching the same data on another UI from DB,
Showing using fuction toDate()
Date1 = 10/14/2015
Date2 = 10/25/2015

In Internalization Settings also the Primary timezone is EST5EDT.
Why it is converting one date (DATE2 only) to EST5EDT time while not converting other(DATE1)?

Any explaination for this situation?
Thanks in Advance.

Discussion posts and replies are publicly visible

0 gpolk over 9 years ago

yes when Date 1 is converted to a datetime it is converted to midnight. Then when date 1 is displayed as datetime the engines assume it is midnight GMT and convert it according to the user preferences.
Date 2 is being collected as 10/25/2015 08:47:53 AM and converted to GMT before it is stored in the database.

You can get more info here forum.appian.com/.../Date_and_Time_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel