Use Change Data Value flowstep for DateTime field

[Anonymous]

Hi Everyone,

    Hopefully this is a simple thing that I am just overlooking, but couldn't find out how to make this work and didn't see a previous thread on the topic.

What I am trying to do is a simple change data value flowstep to set a datetime value in a datetime field. I am trying to set a historical datetime, so the sytem.datetime token won't work for what I'm trying to do.

When I try to use the change data value flow step on the datetime field, it only gives me the option to set the date from the picker. I tried manually typing it it, but it keeps autocorrecting my format. For instance, I want a format of 2018-05-23 22:00:00 (I also tried 22:00, leaving off the second position) however it keeps changing it to 05/23/2018 and completely cuts off the time. I looked in the field setup and confirmed that the field type is a datetime field.

As another approach, I tried putting my value into a temporary string field, then use a lead token to input the value into the datetime field, but the flow step failed as they are two different field types.

Any ideas how to get the value into this field by using a flow step? I am trying to update over 230k records using a scheduled batch process, so I'd rather not go the route of manually uploading lists to update the field values.

Thanks!

Jason

[Jackie_Potts]

I think that it only allows you to add the date there and it won't allow more detail.

[SanfordWhiteman · Accepted solution]

I think that it only allows you to add the date there and it won't allow more detail.

Actually, it's a UI bug. The full Datetime will still be set (well, the hours and minutes -- seconds are discarded, for reasons unknown, in various places in Marketo).

When you refresh the page, it will be cosmetically reformatted to MM/dd/yyyy:

But the underlying value is stored, as you can see on the Status page:

And the stored value is used during campaign execution:

[Anonymous]

Ah okay, thanks Sandford! I'll alert Marketo support about this. They may already have this on their radar, but it couldn't hurt.

Jason