Between DateAdd (1 Viewer)

azhar2006

Registered User.
Local time
Today, 11:22
Joined
Feb 8, 2012
Messages
202
Hi friends
I am trying to write a report that needs to have a date range of 60 days before the current date all the way through the last day of the year. Getting stumped on how I would do 60 days before the current date?
Thank you so much
 

plog

Banishment Pending
Local time
Today, 13:22
Joined
May 11, 2011
Messages
11,611
Sounds like you've got it all thought through, even put the right function name in your thread title. Post some code to show what you tried.
 

azhar2006

Registered User.
Local time
Today, 11:22
Joined
Feb 8, 2012
Messages
202
Ha ha thank you my friend for this beautiful compliments. Yes, I know the job but I do not know how to formulate it correctly. I tried hard. Thank you .
 

plog

Banishment Pending
Local time
Today, 13:22
Joined
May 11, 2011
Messages
11,611
You tried hard, now show that work.
 

azhar2006

Registered User.
Local time
Today, 11:22
Joined
Feb 8, 2012
Messages
202
Between DateAdd("d";-30;Date()) And DateAdd("m";-4;Date())
 

plog

Banishment Pending
Local time
Today, 13:22
Joined
May 11, 2011
Messages
11,611
Your initial post is about 60 days before the current date. Why do I not see "60" anywhere in that code?
 

Users who are viewing this thread

Top Bottom