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