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,
Solved! Go to Solution.
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?
Toss in "HH %p" in the custom format field, looks like maybe this got wiped out somehow.
Great, I just changed to HH %p now it looks good,
Last thing, what am trying to do is, if the HourStart field is 12 AM than TimePeriod should be like 12 AM To 1 AM. So, I how I change the HourEnd field to 1 AM ?
Thanks again..
Yes, you are right and, now I got everything what I needed.
Thank you..
You bet, glad it worked!