SOLVED

Use Change Data Value flowstep for DateTime field

Go to solution
Anonymous
Not applicable

Use Change Data Value flowstep for DateTime field

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

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Use Change Data Value flowstep for DateTime field

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).

pastedImage_1.png

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

pastedImage_0.png

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

pastedImage_5.png

And the stored value is used during campaign execution:

pastedImage_8.png

View solution in original post

3 REPLIES 3
Jackie_Potts
Level 7 - Champion Alumni

Re: Use Change Data Value flowstep for DateTime field

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

SanfordWhiteman
Level 10 - Community Moderator

Re: Use Change Data Value flowstep for DateTime field

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).

pastedImage_1.png

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

pastedImage_0.png

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

pastedImage_5.png

And the stored value is used during campaign execution:

pastedImage_8.png

Anonymous
Not applicable

Re: Use Change Data Value flowstep for DateTime field

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