1st or 3rd Wednesday 90 days out.

[Thelaxman]

Sorry if something like this has been asked before, haven't seen any answers. I am working on a database with a query needed to show a date to review files. The date would be 90 days out taking place on the last 1st or 3rd Wednesday of the month within that 90 day period.

Thanks for any help!

[CJ_London]

don't have time to provide an exact solution but the basic components are

dateadd("d",90,Date()) gives you 90 days out

day(dateadd("d",90,Date())) gives you the day of the month 90 days out

weekday(dateadd("d",90,Date())) gives you the day of the week - 1=Sunday, 2=Monday, etc - Wednesday=4

so by seeing what day you have and what weekday that is, you can work backwards to find the first or 3rd Wednesday