Days count

[sunilkumarqv]

Hi,

I need days bw months for example.

Date,             Days

31/03/2013   , 30

30/04/2013  , 31

31/05/2013  , 30

Need to automate this in script  like in Days Column.

[tresesco]

Could you explain a bit more about the logic of output and your data?

[sujeetsingh · Accepted solution]

It is quite confusing

You can use interval function

Interval(Date1-Date2,'dd') as Days

[PrashantSangle]

Hi,

Try like

Interval(date-previous(date),'D')

Regards

[amit_saini]

Sunil,

Try this:

Interval(Today()-Date(Date#(Date_Field,'DD/MM/YYYY')),'dd')  as NoOfDays,

Thanks,
AS