Same date (today) each year

  • Thread starter Johnathon Anderson
  • Start date
J

Johnathon Anderson

Hello

Please could you help with this.

I have a crosstab query but I would like to restrict it to just YTD. But
need to the YTD for "each" year included.

So I would like to count the number of records that have a date in the
record - but only up to the same date each year.

I "think" I just need to add a filter to the date criteria row -
but I have tried Format((Date()) ,") and it does not work.

Has anyone any idea how to filter all my date fields just so that only the
records with a date that is less than today's date but for each year

Thanks

J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting year to date data to month to date 3
Excel Vba to change displayed year automatically. 14
Hello happy new year to all, Text box input for year of purchase 0
Date search query 0
Problem with Query Calculation 2
Excel Excel Formula OFFSET maybe? 1
Update table with a Running Total 7
Access 2 Digit year in Access Text Box 3

Top