Hi,
I am looking help to convert the DateHour field to Date & Hour by separating them.
Trying to convert above DateHour field as following Time field.
Many thanks,
Toss in "HH %p" in the custom format field, looks like maybe this got wiped out somehow.
Your HourEnd field should be based off of the EndHour datetime field but it looks like it's formatting the DateHour field. Using the workflow you sent me and only making the one change I mentioned above, I'm getting the right result:
Something like this should do the trick:
I'm adding a field for the ending hour, parsing to just the hour (with AM/PM attached) of both fields, and doing some formatting at the end to concatenate.
Hope it helps!
Thank you very much, This is what I needed,
Now, I only want to change for example, if HourEnd is 1 then TimePeriod should be like 1 To 2 AM
Below is the current fields,
Trying to convert with this,
It looks like there might be an issue with your DateTime tool for your HourStart field (everything is null?). Can you post a screen shot of the tool's configuration?
Sure, Kindly check attached my current workflow.
Thank you
