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

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.

OriginalPostID-175947

OriginalPostID-175947

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data