topic Re: Make Date in QlikView

Make Date

Thu, 10 Apr 2014 09:35:47 GMT

Hi,

I am trying to use Make Date function by Data as :

10042014,11042014,12042014,13042014,150402014,16042014.

Using Script as :

Date:

LOAD

Date( Makedate( Left([Order Date],2), Mid([Order Date],2,4) , Right([Order Date],4)) , 'DD-MM-YYYY') as Date1,

[Order Date]

FROM

And while creating a table its giving the same values.

Thanks

Ankit

Re: Make Date

MK_QSL — Thu, 10 Apr 2014 09:38:02 GMT

Load Date(Date#(Date, 'DDMMYYYY'),'DD-MM-YYYY') as Date Inline

[

Date

10042014

11042014

12042014

13042014

15042014

16042014

];

Update : You can create date as below in UI side...

Date(Date#(Date, 'DDMMYYYY'),'DD-MM-YYYY')

Re: Make Date

alexandros17 — Thu, 10 Apr 2014 09:38:13 GMT

wHEN YOU USE MAKEDATE you must specify always YYYY, MM, DD, then you may convert in other formats :

Makedate( Right([Order Date],4), Mid([Order Date],2,4), Left([Order Date],2) )

Re: Make Date

yduval75 — Thu, 10 Apr 2014 09:38:18 GMT

You have to use Date# function to convert text in Date like this :

Date(Date#([Order Date], 'DDMMYYYY'), 'DD-MM-YYYY')

Re: Make Date

manideep78 — Thu, 10 Apr 2014 09:42:30 GMT

Try this instead of above

Date(Date#(Date,'DDMMYYYY'),'DD-MM-YYYY') as Date1

Hope this helps.

Regards

Manideep

Re: Make Date

Anonymous — Thu, 10 Apr 2014 09:53:30 GMT

Hope this will help.

=Date( Makedate( (Right([OrderDate],4)),(Mid([OrderDate],3,2)),(Left([OrderDate],2))) , 'DD-MM-YYYY')

Re: Make Date

maxgro — Thu, 10 Apr 2014 09:56:38 GMT

replace your script

Date:

LOAD

Date( Makedate( Left([Order Date],2), Mid([Order Date],2,4) , Right([Order Date],4)) , 'DD-MM-YYYY') as Date1,

[Order Date]

FROM

with

Date:

LOAD

Date(Makedate( Right([Order Date],4), Mid([Order Date],3,2) , Left([Order Date],2)) , 'DD-MM-YYYY') as Date1,

[Order Date]

FROM

from online help

MakeDate(YYYY [ , MM [ , DD ] ] )

Returns a date calculated from the year YYYY, the month MM and the day DD.

If no month is stated, 1(January) is assumed.

If no day is stated, 1 (the 1:st) is assumed.

Examples:

makedate(1999) returns 1999-01-01

makedate(99) returns 0099-01-01

makedate(1992,12) returns 1992-12-01

makedate(1999,2,14) returns 1999-02-14

Re: Make Date

rustyfishbones — Thu, 10 Apr 2014 10:00:12 GMT

There is no need to use MakeDate function for this

Date(Date#(Date,'DDMMYYYY'),'DD-MM-YYYY') as MyNewDate

Regards

Re: Make Date

Thu, 10 Apr 2014 10:10:23 GMT

Thanks a Lot.

It worked.

Re: Make Date

MK_QSL — Thu, 10 Apr 2014 10:19:53 GMT

Glad that you have got your desired solution.

Have you tried my solution?

Re: Make Date

syinarosely — Tue, 13 Oct 2020 05:25:02 GMT

Hi,

Need help to convert date in to DD/MM/YYYY

The current format date is 31st december 2020

Re: Make Date

mattleblanc — Tue, 13 Oct 2020 05:33:45 GMT

At the point when YOU USE MAKEDATE you should determine consistently YYYY, MM, DD, at that point you may change over in different configurations