Quick access question

xaber · 15 May 2006 at 11:18

Hi, Does anyone know if there is a function in Access that returns the day of the week of a specified date?

For example day(15/05/06) would return monday?

Had a look through help to no avail!

Thanks

-RV- · 15 May 2006 at 11:56

Have a look at the Weekday function

xaber · 15 May 2006 at 13:33

Cheers for that m8!

Can anyone else tlel me how you can check whether or not a number is even? Need to perform an validation that only allows dates of every other week. Using datepart I can get the week number, but not check if its even

Fezzer · 15 May 2006 at 14:46

xaber said:
Cheers for that m8!

Can anyone else tlel me how you can check whether or not a number is even? Need to perform an validation that only allows dates of every other week. Using datepart I can get the week number, but not check if its even

Code:

[Number] Mod 2

If the result is 0 it even if it's 1 it's odd!!