Fordraiders
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"
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER