Count number of date

[#1]

hi all,

I've problem in counting number of days

if i have table with data like this:

Date

1/1/2011

12/1/2011

12/12/2010

2/2/2012

how to count number of days from today to 'Date'?

I want to count how many days from data 'Date' to today date. any idea?

thanks for your help all!

[deepakk]

hi,

If I am correct. (today() - Date) as Days will give you the required output.

[jagan]

Hi,

Use the following Load script to arrive the difference between Today and Date

LOAD

     Date,

     Interval(today() - Date, 'D') as Days

FROM DataSource;

Hope this helps you.

Regarsd,

Jagan.

[Anonymous · Accepted solution]

Hi

     Hope the attached file will be helpful for your doubt

Regards

Ashok

[#5]

thanks chandashok, jagan, and deepak. its working now! thanks!