script

[mario-sarkis]

please help

how can i write PeriodeDate > 'one year back' in the script ?

[Siva_Sankar]

Load * your table where PeriodeDate = Max(Year(PeriodDate))-1;

[PrashantSangle]

Hi,

In Script

try like

PeriodDate > Date(AddYears(PeriodDate,-1))

Note: Carefull about Date Format.

Regards

[maxgro]

maybe this

A:     // TEST DATA

load

  date(makedate(2014) + floor(rand()*(365*2))) as PeriodDate

AutoGenerate   1000;

B:

load

  PeriodDate,

  PeriodDate as NewPeriodDate

Resident   A

where PeriodDate >= AddYears(Today(1), -1)

  ;

[anbu1984]

One year back of current year??

PeriodDate > AddYears(Today(),-1)

[nirmalraj_kj]

Hi,

Can you try this

PeriodDate=Date(addyears(Today(),-1),'Same as PeriodDate format')

[Siva_Sankar]

if you want only previous year data put = symbol in where, if you want data from previous year put > in where condition.

[#8]

Try this

PeriodeDate >Year(Now())-1

[mario-sarkis]

hey max if the PeriodeDate it shows as number how should i write it ?

[anbu1984]

What is format you have in PeriodDate?