Avatar of Fordraiders
Fordraiders
Flag 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

Microsoft AccessVBA

Avatar of undefined
Last Comment
Fordraiders

8/22/2022 - Mon