topic Re: Query in QlikView

Query

Wed, 17 Sep 2014 09:47:37 GMT

Hi All,

When i putting the MakeDate (2012,04,01) it is giving me the 1/04/2012 in the output ....but when i am adding 1 with the makedate function like below

MakeDate(2012,04,01) +1

then it is giving me the output like 41001

can anybody explain me why is it so...i am confused little bit i.e how it is coming.

Regards

Sarfaraz

Re: Query

PrashantSangle — Wed, 17 Sep 2014 09:50:11 GMT

Hi,

When you added 1, It is converting again your date to num format

Write

Date(MakeDate(2012,04,01) +1)

Regards

Re: Query

tresB — Wed, 17 Sep 2014 09:55:04 GMT

Date is acutally a number at the backend. When you create a date with makedate() it is a number at the backend and Date in the front-end. If a mathematical operation(here'+') has to be done, it takes the backend number and operate accordingly.

Date-1/04/2012 is equivalent to 401000

If you add 1 to it, you get rightly 401001

If you want next date, try: =Date(MakeDate(2012,04,01) +1) // gives you 2/04/2012

Date starts(here) - 31/12/1899 which is actually numerically equivalent to 1.

Re: Query

Wed, 17 Sep 2014 09:57:21 GMT

Hi,

Date(Makedate(2012,04,01)+1,'DD/MM/YYYY')

Re: Query

ychaitanya — Wed, 17 Sep 2014 10:03:29 GMT

Yes

Date(MakeDate(2012,04,01)+1) as My_Date Should work....

Regards Chaitanya

Re: Query

Wed, 17 Sep 2014 10:12:42 GMT

Hi Tresesco,

Thanks for your reply!!

I got the point...but one thing i did not understand that is ...how this number 401000 is calculated for the respective date 1/04/2012....

Regards

Sarfaraz

Re: Query

tresB — Wed, 17 Sep 2014 10:23:55 GMT

As my last line says it is a standard (as in MS Excel), The first date is 31/12/1899 =1, then every day is one more to integer, like:

31/12/1899-1

1/1/1900-2

2/1/1900-3

.....

Read this: QlikView Date fields for more details.

Re: Query

Wed, 17 Sep 2014 10:51:59 GMT

Hi Tresesco,

Thanks for your Help!!!!!!

I understood what you told....

Regards

Sarfaraz

Re: Query

Wed, 17 Sep 2014 10:53:18 GMT

Hi ALL,

Thanks guys for your Valueable Reply's ........I got the Answer....

Regards

Sarfaraz