Script prob

[nikhilgarg]

Hey,

I have a doubt that:

I am writing script where i ahve to fetch data for current fiscal year only as:

Table1:

Load a,

b,c from def.qvd(qvd) where TRANS_DATE >= if(num(month(Today())) < 11 , (year(Today()) - 1)-11-01 , year(today()-11-01)) and

TRANS_DATE <=today();

does my script after where clause is correct ?

[jonathandienst · Accepted solution]

Use the Fiscal offset in YearStart:

Where TRANS_DATE >= YearStart(Today(), 0, 11) And TRANS_DATE <= Today()

[Gysbert_Wassenaar]

(year(Today()) - 1)-11-01 = 2014-11-01 = 2014-12 = 2002 = the 26th of june 1905.

[sunny_talwar]

1) (year(Today()) - 1)-11-01

2) year(today()-11-01))

Everything looks good, but what exactly you are trying to do with these two above??