Converting date from one format to another format

[Anonymous]

I have a Data set which has "Time" as 01/22/2016 21.21.47 PM"

So i need to show that Time to,

January 22,2016 only.

Please help me.

Thanks,

Chandra

[sunny_talwar]

You cannot have your time in 24 hr format and have AM/PM at the end. Assuming there is not AM/PM, try this:

Try this:

Date(Floor(TimeStamp#('01/22/2016 21.21.47', 'MM/DD/YYYY hh.mm.ss')), 'MMMM DD, YYYY') as Date

[Anonymous]

may be this only?

=date(YourTimeField,'MMMM DD, YYYY') as DateTime