Query to keep count of current days, months, quarters YTD? (1 Viewer)

[gojets1721]

I have a bit of an odd one....I was wondering if there's a way to have 1 (or 3 if needed) queries just keep a running separate count of how many days have passed YTD, how many months YTD, and how many quarters YTD.

So as of today, I would want to show 28 days in one field, 1 month in another, and 1 quarter in another.

I hope that makes sense. Any suggestions?

 

[theDBguy]

Would DateDiff() work for you?

 

[CJ_London]

When does your year start since if 1st Jan month and quarter should be 0 if you want past

 

[MajP]

You said "Passed" but your example shows what day, month, and qtr we are currently in not what has passed.

SELECT Datediff("d", Dateserial(Year(DATE()), 1, 1), DATE())
       + 1                 AS DayOfYear,
       Month(DATE())       AS MonthOfYear,
       Format(DATE(), "q") AS Quarter;