Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
hi,
If I am correct. (today() - Date) as Days will give you the required output.
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.
Hi
Hope the attached file will be helpful for your doubt
Regards
Ashok
thanks chandashok, jagan, and deepak. its working now! thanks!