AnsweredAssumed Answered

Use Change Data Value flowstep for DateTime field

Question asked by 616794319344a9aff4b49c1a0515ea047fdd2d0c on Jun 8, 2018
Latest reply on Jun 12, 2018 by 616794319344a9aff4b49c1a0515ea047fdd2d0c

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.