Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Use the Fiscal offset in YearStart:
Where TRANS_DATE >= YearStart(Today(), 0, 11) And TRANS_DATE <= Today()
Use the Fiscal offset in YearStart:
Where TRANS_DATE >= YearStart(Today(), 0, 11) And TRANS_DATE <= Today()
(year(Today()) - 1)-11-01 = 2014-11-01 = 2014-12 = 2002 = the 26th of june 1905.
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??