how to count number of days from April to till date(today())

[kunkumnaveen]

Hi All,

How to count number of days from 1st of April to till date .will it be done at Script level or frontend ...

thanks

[jonathandienst]

This will count number of days:

MakeDate(2018, 4) - floor(yourdatefield)

[kunkumnaveen]

HI, when I use your code

=MakeDate(2018, 4) - floor(today())  I am getting 33 as Out put .but it has to be more then 200 days

[kkkumar82]

Is it April 2017 ?

[kunkumnaveen]

From Calendar date 1st April 2017 to today()

[kkkumar82 · Accepted solution]

then change the year in the above code to 2017

floor(Today()) - MakeDate(2017, 4)

[pradosh_thakur]

today() - makedate(2017,4)

or

interval(today() - makedate(2017,4).'DD')