How to get the name of a date in Access VBA

[hazeleyre23]

Hi,



I want to be able to get the name of a date in Access.

I have a control called Date Chased and If that is a Thursday then I want to add 4 days onto Date Chased Second control , else 2.

Thanks

Hazel

[CJ_London]

use the weekday function to determine the day of the week

1=Sunday
2=Monday
etc

so your formula would be something like

datechased2=datechased+2-(weekday(datechased)=5*2)

what about Friday?