Please correct the formula below I am not getting any values

[techvarun]

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]

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]

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

[t_moutault]

hi,

can you tell us what you want to achieve ?

[nagaiank]

You may try this:

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

[#6]

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

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