Date Formatting

[#1]

We have a date field (ex. 7/9/2010 14:36) which QV doen't see as a date. What function do we use for QV to read it as a date and also we need to separate it into three different fields as a Year, Month, Date.

Thank you

[#2]

Hi,

use

Date(Timestamp#('DD/MM/YYYY hh:mm')) as MyDate

and time functions like Year(MyDate) as Year and so on.

See QV help for more details.

Good luck!

Rainer

[#3]

Hi Rainer,

Thanks for a quick reply, but that did not work. Any other suggestions?

Polina

[syed_muzammil]

Hi,

You can use the date( expression [ , format-code ] ) .

Where format code is the format u want the date to be in.

[#5]

We used this expression

Date(Timestamp#([Last Updated],'DD/MM/YYYY hh:mm')) and it worked.

Thanks for your help.

[johnw]

I recommend:

date(floor(timestamp#([Last Updated],'DD/MM/YYYY hh:mm')))

Without the floor() function, it is only DISPLAYING as a Date, but there is still a time associated with it. So you can get multiple "dates" that all look the same.