topic Re: Please correct the formula below I am not getting any values in QlikView

Please correct the formula below I am not getting any values

techvarun — Thu, 21 May 2015 12:09:19 GMT

Hi Experts

Can anyone please fix the formula below

num(makedate(year(today()),month(today()),Date(today(),'DD'))),

When i run the script in pieces I am getting the results as below

year(today()), 2015

month(today()) 05

Date(today(),'DD'), 21 but as in makedate() i am getting null as the result

Thanks

Varun

manishnarang — Thu, 21 May 2015 12:27:48 GMT

Try this:

=num(makedate(year(today()),month(today()),Day(today())))

But what is the actual requirement?

you can take the num of today's date simply as : =num(Date(Today()))

anbu1984 — Thu, 21 May 2015 12:30:41 GMT

=Num(makedate(year(today()),month(today()),Day(today())))

t_moutault — Thu, 21 May 2015 12:54:24 GMT

hi,

can you tell us what you want to achieve ?

nagaiank — Thu, 21 May 2015 13:03:18 GMT

You may try this:

=Date(num(makedate(year(today()),month(today()),Day(today()))))

Thu, 21 May 2015 13:03:41 GMT

the day part of the makedate expression seems to be the issue. try this

makedate(year(today()),month(today()),Day(today()))