Change date format

[#1]

Dear all,

How can I change below dateformat into a usable one:

Sep 30 2013 12:58AM

I already have the time covered, but I cannot seem to get the date converted.

[israrkhan]

try

=Date(Floor(DateField), 'DD/MM/YYYY') AS DATE

[janardhan]

Hi ,

Go to properties , in Number Tab select which expression u want to convert date format and select Date in Number format settings , from there u will convert date format as u like.

I Hope this will helps.

[Jason_Michaelides]

You may need to force QV to recognise your field as a date-time first:

Date(Date#(Left(DateField,11),'MMM DD YYYY'),'DD/MM/YYYY')

This will only work if you know DateField is always MMM DD YYYY hh:mm

Hope this helps,

Jason

[#5]

Yes, Now I get the date in a useable format. But there is always a next question... to really calculate with this I need the timestamp as well. And if I use this field in the timestamp formula I get strange dates. Any thoughts?

[Jason_Michaelides · Accepted solution]

Try,

Date(TimeStamp#(DateField,'MMM DD YYYY hh:mmtt'),'DD/MM/YYYY')

Hope this helps,

Jason

[#7]

Dear Jason,

This works if the format is Oct 30 2013 10:09PM, but it goes false if any of the data is in another format, like:

Nov 1 2013 10:09PM or

Oct 30 2013 9:09PM

Any ideas how to tackle this?

[Jason_Michaelides]

Date(TimeStamp#(DateField,'MMM D YYYY h:mmtt'),'DD/MM/YYYY')

[#9]

No, that does not work...

[Jason_Michaelides]

What does it return?