Hello All,
I have a database where I need all dates entered into Date Fields to convert to Estern Standard Time (EST) when the document is saved.
I am willing to do this with @Formula, LotusScript, or field attributes. Which ever will work…
Any thoughts or advice would be great!
Thank you in advance!
JB Dunmyer
Subject: Converting All Dates to EST
Assuming the dates were entered using the Notes client, and the client’s time zone was set correctly when the data was entered, the dates are already stored with time zone information. You will need to create a calculated field using @TimeToTextInZone. The field’s formula would be something like,
@TimeToTextInZone(DateTime; “Z=5$DO=1$DL=3 2 1 111 1$zX=29$ZN=Eastern”)
I derived the zone info from a TimeZone field set to Eastern time, which would be a safer way for you to do it, rather than copying what I posted. You could even include a hidden (or not) Time zone field and replace the 2nd parameter in the above formula with the name of the field (TimeZone).
You say that you want EST. Do you mean that you never want EDT (daylight)? If so, that’s an additional complication that I’m not prepared to address right now.