Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try this
Date(Floor(Date#(Replace(Date, ' ', ' '), 'MMM D YYYY hh:mm[.fff]TT')),'MM/DD/YYYY') as MyNewDate;
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..
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
I really thought TRIM() removes all spaces including those in the middle... Thank you
Nope, that is what you use Replace() for..
Yes, I see