Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

getting a date only with a months range

getting a date only with a months range

using the code below:
I'm getting a date like '2/22/202 01:20:34 am'

What I need: i need to go back within the previous month only  
say today is 4/14/2020.

03/01/2020 to 03/31/2020  if the "last_date" falls within this range >=  and  <=  

then bring up a msgbox  "Ok to proceed"  


QS_RACFID = Me!EMPLOYEE_RACFID
Dim last_Date As Date
last_Date = DMax("LASTMODIFIED", "dbo_EXTRACT_2020", "[updttype] = '" & QS_RACFID & "'")

MsgBox " '" & last_Date & "'", vbDefaultButton1

Exit Sub

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fordraiders

ASKER

Thanks  Jim.