Validation Code Date must a Friday

PNGBill

Win10 Office Pro 2016
Local time
Tomorrow, 09:17
Joined
Jul 15, 2008
Messages
2,269
Hi There,
What is the code to validate a date on a form field, when it is entered, so it is rejected if it is not a Friday??
I have searched for this in date issues for sometime and have not found a reference for same.
Regards,
Bill:confused:
 
how about something like...

if left(Format(Field_Name, "Long Date"),1) <>"F" then...

Brett
 
If weekday(YourDate) <> 6 Then
 

Users who are viewing this thread

Back
Top Bottom