Want to add 0 in front of time. My time is stored in string variable

[Puneet_Singh]

1:00 PM(PDT)
Above is time format stored in string variable and i want to append 0 in start of time like 01:00 PM(PDT).

Trying different things but no use.

[arjunshenoy]

Hi @Puneet_Singh

Try this:

Assign
InputTime = “1:00 PM(PDT)”

Assign
FormattedTime = DateTime.ParseExact(InputTime, “h:mm tt’(PDT)'”, CultureInfo.InvariantCulture).ToString(“hh:mm tt’(PDT)'”)

Hope this helps,
Best Regards.

[Puneet_Singh]

I already deleted PDT its not in use and i tried your solution it showing cultureinfo is not declared.

[arjunshenoy]

@Puneet_Singh

Since you said you have stored it in a string variable, try concatenation:

“0”+stringVar

Hope this helps,
Best Regards.

[Anil_G (Anil Gorthi)]

@Puneet_Singh

Try this

If(Str.Split({":"},2,StringSplitOptions.None)(0).Length=2,"","0") + Str.Split({":"},2,StringSplitOptions.None)(0) + ":" + Str.Split({":"},2,StringSplitOptions.None)(1)

Cheers

[postwick (Paul)]

You shouldn’t deal with datetimes as strings by doing all this splitting. Convert them to proper datetime then output the format you need.

[fernando_zuluaga]

Hi @Puneet_Singh

Give a try with the following

DateTime.ParseExact(strInput, "h:mm tt'(PDT)'", System.Globalization.CultureInfo.InvariantCulture).ToString("hh:mm tt'(PDT)'")

Regards