Date format Issue

[amit_saini]

Hi Folks,

I'm trying to change Date format , but not sure why only some records are changing and not all.

Date(Date#(Date, 'MMM  DD YYYY  HH:MM[.fff]TT'),'MM/DD/YYYY') as MyNewDate,

I want to convert Date to this Format : 2/24/2015  9:30:15 AM

PFA!

Regards,

As

[sunny_talwar]

Try this

Date(Floor(Date#(Replace(Date, '  ', ' '), 'MMM D YYYY hh:mm[.fff]TT')),'MM/DD/YYYY') as MyNewDate;

[YoussefBelloum]

Hi stalwar1‌,

in this exampe using an inline, does Replace(Date,' ','') act like Trim(Date) ? because I was trying with Trim(Date) and it didn't work..

[sunny_talwar · Accepted solution]

Trim removes extra spaces from the beginning and ending of the string... here I am replacing two spaces with a single space in between the string

[YoussefBelloum]

I really thought TRIM() removes all spaces including those in the middle... Thank you

[sunny_talwar]

Nope, that is what you use Replace() for..

[YoussefBelloum]

Yes, I see