Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please explain anyone...
Thanks in Advance....
Hi,
You could not use the date of recharge function Today () - in your where? Something like below:
WHERE DAT> Date (today () -1095, 'DD / MM / YYYY')
Rebeca
Hi Rebeca,
Please find my attachment table..
in my table i have 2003,04,05,06 and 2007 years data.
Read only the current 3 years of data using a variable (No hard-coding)
how to get please explain.....
Thanks in Advance..
Hi,
Create a variable and assign the maximum year to it.
Then while loading the data load only last 3 years data...ex: variable-3
Regards,
Amay
Hi,
if i am using today() function it returns 2013.
but i have years 03,04,05,06 and 07 years.
how can i get year
Hi,
today() - 1095
will show the date three years ago, 365 for each year.
Rebeca