change date time format to MON-DD-YYYY HH24:MI:SS

[smrithiraj]

Hey there

I did not find a way to convert to a custom date time to MON-DD-YYYY HH24:MI:SS format ... Please help

Thanks

Smrithi

[gawa]

hi @smrithiraj 

In DateTime tool configuration, specify "Custom", and input the format of incoming string field.

[gawa]

Sorry, I misunderstood requirement. You want to change "TO" MON-DD-YYYY HH24:MI:SS format.

Then, please try this WF, basic concept is not changed though.

[smrithiraj]

The format for month should be in capital letters MON i.e JAN, FEB, MAR etc. and the time should be in 24 hour format which I did not find... Please help

[gawa · Accepted solution]

@smrithiraj 

You can use UpperCase function to make MON. Time format is already in 24 hour style. Please check it out.