Hi
I make a modification in my existing query:
SELECT datepart("q",[Data e fillimit te tremujorit]) & year([Data e fillimit te tremujorit]) AS PeriodQuarter, clng(IIf(left(PeriodQuarter,1) In (2,3,4),year([Data e fillimit te tremujorit]),year([Data e fillimit te tremujorit])-1)) AS FiscalYear, *
FROM Konsumi_Disaperiudha1_Gimi;
using NZ function.
Now it seems
SELECT DatePart("q",[Data e fillimit te tremujorit]) & Year([Data e fillimit te tremujorit]) AS PeriodQuarter, CLng(IIf(Left(PeriodQuarter,1) In (2,3,4),Year(NZ([Data e fillimit te tremujorit], 2) - 1))AS FiscalYear, *
FROM Konsumi_Disaperiudha1_Gimi;
Anyway my query is reporting Syntax Error.
Please help repair
Regards