Read only the current 3 years of data using a variable (No hard-coding)

[Nagaraju_KCS]

Hi All,

Please explain anyone...

• Read only the current 3 years of data using a variable (No hard-coding)

Thanks in Advance....

[#2]

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

[Nagaraju_KCS]

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..

[#4]

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

[Nagaraju_KCS]

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

[#6]

Hi,

today() - 1095

will show the date three years ago, 365 for each year.

Rebeca