Hi
If I'm right we are in Quarter =1 ,so why my following query brings the result quarter=2 ?
Select
DatePart("q",Now()) AS Financial_Quarter,
"01/04/" & IIf(DatePart("q",Now())=1,Year(Now())-1,Year(Now())) As Fi
FROM Table_Name
Ans= 2 ?
Thanks in advance
Many thanks
Farhan