topic Re: Date Type in QlikView

Date Type

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hey Community,

I have Field date whit the following Build

Date

May 1, 2015

January1,2015

June 8, 2015

July 1, 2015

June 8, 2015

July 1, 2015

June 8, 2015

My question is how can i get the Year Month And Day at separate, I try to use Year month and day function but it dint work for me e.c

Year:2015....

Month:June,July....

Thx

Hey guys, I said i try to use the function Year(), Day(),Month() But it didnt work. i add the app and screen shot hope you will help me Thank you guys

Re: Date Type

Anonymous — Tue, 05 Apr 2016 15:59:08 GMT

Hi,

There were many ways to do this one of them of them is...

Go to Script:

LOAD Date,

Year(Date) As Year,

Month(Date) As Month,

Day(Date) As Day;

Thanks

Vinay.

Re: Date Type

Chanty4u — Tue, 05 Apr 2016 16:08:51 GMT

yes u can extract from the Date field as below

year(Datefield) as year,

Month(Datefiled) as Month,

Day(Datefield) as day...lik so on chk below link

Master Calemder

Re: Date Type

jonathandienst — Tue, 05 Apr 2016 16:13:06 GMT

Date(Date#(Date, 'MMMM dd, yyyy')) as Date,

Year(Date#(Date, 'MMMM dd, yyyy')) as Year,

Month(Date#(Date, 'MMMM dd, yyyy')) as Month,

...

Re: Date Type

sunny_talwar — Tue, 05 Apr 2016 16:18:20 GMT

This:

Table:

LOAD *,

Year(Date) as Year,

Day(Date) as Day,

Month(Date) as Month,

MonthName(Date) as MonthYear;

LOAD Date#(Date, 'MMMM D, YYYY') as Date Inline [

Date

May 1, 2015

January 1, 2015

June 8, 2015

July 1, 2015

June 8, 2015

July 1, 2015

June 8, 2015

] (delimiter is |);

Re: Date Type

Anonymous — Wed, 06 Apr 2016 06:37:07 GMT

Thank you but as i say i try already this method and its not work,

i add the app and screen shot.

Re: Date Type

Anonymous — Wed, 06 Apr 2016 06:40:12 GMT

Thx but as i say before this method does not work for me, i add the app and screen shot for you guys,

P.s i find jontydkpi solution good enough.

Re: Date Type

Anonymous — Wed, 06 Apr 2016 06:42:11 GMT

its work but still you can find at the app that two dates are in different type,

if you load the original data you will find that there is 2 dates that have only year and whit your solution it dont bring them back.

Re: Date Type

Chanty4u — Wed, 06 Apr 2016 06:46:57 GMT

chk attached

Re: Date Type

Anonymous — Wed, 06 Apr 2016 06:48:51 GMT

Props to Chanty 4u: Beer!

I owe you a beer!

Re: Date Type

Chanty4u — Wed, 06 Apr 2016 07:07:31 GMT

Thnks But I dont drink

Re: Date Type

jonathandienst — Wed, 06 Apr 2016 10:37:59 GMT

david Ben Shimol wrote:

its work but still you can find at the app that two dates are in different type,

if you load the original data you will find that there is 2 dates that have only year and whit your solution it dont bring them back.

Its a pity you did not include that information in your post, but its not that difficult to handle. Just use Alt() to select the first date conversion that works - assuming taht the alternative is a year like "2016", then:

Date(Alt(Date#(Date, 'MMMM dd, yyyy'), Date#(Date, 'yyyy'))) as Date,

You can add as many alternatives as necessary. You may want to do the Year and Month extraction from the date into a preceding load for simplicity and clarity.

Re: Date Type

Anonymous — Thu, 07 Apr 2016 11:27:34 GMT

If i have date field that looks like this

20071103 how can i make it look like 11/03/2007 ?

Re: Date Type

Chanty4u — Thu, 07 Apr 2016 11:46:53 GMT

TRY THIS

Date#(Datefield,'YYYYDDMM'),'DD/MM/YYYY') AS NEWDATE