Last Year Month to Date Query

[stephaniediedenhoven]

I'm getting my this years month to date with


Between [Forms]![Westwood Night Audit]![Start Date] And [Forms]![Westwood Night Audit]![CHQ#_Date].


How can I use the same to get Last Years Month to Date?
Example: today is 17Dec20 and my month to date is 1Dec20 to 17Dec20. Now I also need a the same column but with last years month to date.

I know it should be easy but I just can't get it to work. Hopefully someone can get it to work.

[Welshgasman]

Use DateDiff() and subtract a year?

[ranman256]

yes, datediff("yyyy",-1,Date())

put some controls on your form to help fill the start/end date. Month-to-date, month, week,etc...
then just click the 'range' to fill in the date boxes.

[stephaniediedenhoven]

Thanks for the quick response that was what I was looking for. Now it works.

[ssanfu]

Be aware that object names (field, table, form, report, query, module) should only be letters and numbers, exception is the underscore(_).
Should NOT use spaces, special characters or punctuation.
Should not begin an object name with a number


Example:
Bad

Between [Forms]![Westwood Night Audit]![Start Date] And [Forms]![Westwood Night Audit]![CHQ#_Date].

Has spaces and the hash mark (# - the Date delimiter)
Better

Between [Forms]![WestwoodNightAudit]![StartDate] And [Forms]![WestwoodNightAudit]![CHQ_Date].

No spaces, no special characters...



And Welcome to the forum....