Adding a timestamp to a preference centre change log - timezone problems!! | Community
Skip to main content
Gary_Verster2
Gary_Verster2
New Participant
December 5, 2017
Solved

Adding a timestamp to a preference centre change log - timezone problems!!

  • December 5, 2017
  • 2 replies
  • 4063 views

Hi everyone,

In preparation for GDPR next year, I'm trying to create a text field that will capture every change that our users make on our preference centre, including a timestamp.

I've already created the preference opt-ins and the timestamps - these are all pretty much working as I'd like. But in the trigger campaign that writes the [timestamp + preference change] to the change log, the timestamp gets changed, even though the timestamp field itself is correctly populated.

Here is the flow for the smart campaign concerned:

(I've already worked out that Marketo doesn't like adding a boolean as a token in Step 2, hence the 'choice' approach).

I've tried adding the {{system.dateTime}} token to the Change Log instead, but the result is the same. I assume this is something to do with timezones?

Anyone have any ideas?

Regards,

Gary

Best answer by SanfordWhiteman

Hi Gary, this is expected behavior... think of it like running plain toString() on a date, which outputs it in the current tz + locale (even though it is stored as UTC).

2 replies

M
Mark_Price
New Participant
December 6, 2017

Hi Gary,

Nice to see another blog.teknkl.com subscriber. 

hmm, that's a strange problem. Can you post a screenshot of the activity log maybe ?

What if you did this to set the change log :

{{system.dateTime}} User changed Alerts Opt-In to TRUE. | {{lead.Consent - Change Log}}

Gary_Verster2
Gary_Verster2Author
New Participant
December 6, 2017

I tried using the {{system.dateTime}} token, too. Same result...

As you can see here, the Timestamp field is populated just fine, but as soon as you 'write' the timestamp to the text field, I lose 4 hours! Strange.

I guess the alternative is for me to add a timezone to the Change Log, i.e. EST (or whatever), so that if we ever need to use the log, we know to facto it in.

Oh, and a general little testing tip that might be worth noting... when you use gmail addresses for testing, you can create as many aliases as you want (How to Hack Your Gmail Address to Add Accounts ). Really useful!!

A
Anonymous
December 6, 2017

Hi Gary,

What value do you see in lead info tab for preference alert timestamp?

Did you try adding 2 min wait in these steps?

Thanks,

Gunjan

M
Mark_Price
New Participant
December 5, 2017

Hi Gary,

The changelog step could be the issue.  It looks like it might only store your last value instead of a rolling history.

Maybe try something like this in the flowstep:

{{lead.Consent - Preference - Alerts Timestamp}} User changed Alerts Opt-In to TRUE. | {{lead.Consent - Change Log}}

^ you could also just use the system date stamp here.

**Note: Check the token on the Consent - Change Log, this is just an example. Also you can use something other than a pipe character to split the values.

    Gary_Verster2
    Gary_Verster2Author
    New Participant
    December 6, 2017

    Hi Mark,

    Thanks for the reply, chap.

    Yeah, I was planning to prepend to the Change Log using @Sanford Whiteman's line-break token trick (http://blog.teknkl.com/dark-mkto-alleys-line-break-token/) instead of using a pipe; just wanted to get the actual timestamp bit populating correctly first. Marketo seems to populate the Consent - Preference - Alerts Timestamp field correctly, but when I try to add the timestamp to the Change Log, it weirdly defaults to EST. Not ideal...

    Terms & ConditionsAccessibility statement

    Loading footer...