topic Re: Date format in QlikView

Date format

Anonymous — Mon, 06 Apr 2015 14:31:19 GMT

Hello:

I've been having trouble with the date format, this is my problem:

I have the following date format: 01-08-2006 0:00:00

And I just need the year (2006).

Do you have any idea of the best way to get it?

Thanks a lot

sunny_talwar — Mon, 06 Apr 2015 14:36:10 GMT

try this in the script if your date is MM-DD-YYYY

LOAD Year(Date#(yourDateField, 'MM-DD-YYYY h:mm:ss') as Year

if date is DD-MM-YYYY, then use this:

LOAD Year(Date#(yourDateField, 'DD-MM-YYYY h:mm:ss') as Year

HTH

Best,

Sunny

agomes1971 — Mon, 06 Apr 2015 14:38:19 GMT

Hi,

HTH

André Gomes

avinashelite — Mon, 06 Apr 2015 14:39:08 GMT

try like this:

year(Date(floor(date_feild),'MM/DD/YYYY'))

Anonymous — Mon, 06 Apr 2015 14:55:38 GMT

Thanks alot! that worked just fine!

Anonymous — Mon, 06 Apr 2015 14:56:25 GMT

Thanks alot! that worked just fine!

avinashelite — Mon, 06 Apr 2015 14:57:51 GMT

cool, Please mark it as answered and close this thread