Fiscal Month Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a query where it displays all dates in a fiscal month.

Fiscal Month runs from the 21st to the 20th

so if i run a querie for this month it should show the dates for May 21st
through June 20th. (The month to be displayed will change depending on what
month the current form is displaying)
 
Could be a better way, bt you can try

Between
DateSerial(IIf(Day(Date())<20,Year(DateAdd("m",-1,Date())),Year(Date())),IIf(Day(Date())<20,Month(DateAdd("m",-1,Date())),Month(Date())),21)
And
DateSerial(IIf(Day(Date())>20,Year(DateAdd("m",1,Date())),Year(Date())),IIf(Day(Date())>20,Month(DateAdd("m",1,Date())),Month(Date())),20)

In that example, I refered to the current date
If the date above the 20, the criteria will be from the 21 in this month to
next nonth.
Under 20 it will be from 21 of previous month to 20 of this month
 
Worked perfectly! I am able to take it from here,

Thank you, thank you, thank you, thank you, thank you, thank you, thank you,
thank you, thank you, thank you, thank you, thank you, thank you, thank you,
thank you!
 
Back
Top