1

I have cloud pages sign up forms that have a hidden field for a date/time stamp upon submission. We are simply using Now() and it works great - except the data is in CST, and not EST.

I did some research and a suggestion was to use the Default Date/Time in a DE to set the value, but that too is in CST (I checked under Admin, our account is listed as EST).

We can do a DateAdd but then we'd have to change this every 6 months (too risky, not slick).

value="%%=DateAdd(Now(),"2","h")=%%"

Has anyone had luck finding a way around this?

Improve this question

1 Answer 1

Reset to default
0

You might take a look at the SystemDateToLocalDate() AMPScript function:

Local Time For User: %%=SystemDateToLocalDate(Now())=%%

Improve this answer
5
  • Thought about that, but if a user is on the West Coast we still need the data to be in EST, as we want all of our data to be consistent.
    – George Rosedale
    Commented Mar 27, 2017 at 21:34
  • Well, if you want it consistent (and would like to stay sane), then I'd suggest sticking with CST.
    – Adam Spriggs
    Commented Mar 27, 2017 at 22:15
  • @AdamSpriggs All Date/Time values are stored in Salesforce in GMT format - what do you mean by consistency?
    – o-lexi
    Commented Mar 27, 2017 at 22:24
  • UTC time in Marketing Cloud? Where?
    – Adam Spriggs
    Commented Mar 28, 2017 at 1:13
  • I think we might just do the transformation within our offline DB when the data is imported. Thank you for the input @AdamSpriggs
    – George Rosedale
    Commented Mar 28, 2017 at 1:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .