Solved Format function to get Current financial year data from (April-20 to March-21) (1 Viewer)

[hrdpgajjar]

SELECT DataBase.[Regi No], DataBase.[Farmer Name], DataBase.Village, DataBase.Taluka, DataBase.District, DataBase.[MIS System], DataBase.[Area (Ha)], DataBase.[Sent to GGRC Date]
FROM [DataBase]
WHERE DataBase.[Sent to GGRC Date]) Between DateAdd("yyyy",-1,fnFinancialYearStart(Date())) And fnFinancialYearStart(Date())-1;

This works, thanks

 

[hrdpgajjar]

SELECT DataBase.[Regi No], DataBase.[Farmer Name], DataBase.Village, DataBase.Taluka, DataBase.District, DataBase.[MIS System], DataBase.[Area (Ha)], DataBase.[Sent to GGRC Date]
FROM [DataBase]
WHERE DataBase.[Sent to GGRC Date]) Between DateAdd("yyyy",-1,fnFinancialYearStart(Date())) And fnFinancialYearStart(Date())-1;

this works.