How can I set the value of a Date-Time field from a Text ?

Options
Rafael_943505
Rafael_943505 Posts: 21
in Questions

Hi,
I have a text that contains a date and time in the format dddd,MMMMD,YYYY h:mA. I would like to transform this into a Date - Time field. or perhaps only a Time field
The Action Dates: Set value of a date field only pulls back the date, but I'm more concerned about collecting the time from this text.
Is there a way I can transform this h:mA format into a HH:mm format?

Tagged:

Answers

  • Brandon_189578
    Brandon_189578 Posts: 36
    Options

    Hello Rafel,

    Could you provide an example of a datetime in the starting format? The standard way to handle something like this would be to parse the input text into a datetime via Dates: Set value of a date field action, and then Dates: Format a date time to format it differently. However, I haven't see the dddd,MMMMD,YYYY h:mA format before, so that may not work as easily as normal.

    Having a sample will make it easier to determine if manipulating the date prior to parsing is necessary.

    Regards,
    Brandon

Categories