Weekday Function

[dsthome]

Having a bit a brain freeze today. I have a field that auotmatically puts a date in when a checkbox is checked I am now trying to add a field which returns the day of the week from this date. Brain now mashed I am sure it's pretty simple but I just can't get it to work any help would be greatly appreciated.

 

[vbaInet]

You need the WeekDay() function. Have a look here:

http://www.techonthenet.com/access/functions/index.php

 

[dsthome]

Hi Thanks for that, I appear to only be hlaf wey there I have got it to return a number, how do I change this to an actual day. Here is the code I used

=Weekday([Iss Date])

What am I doing wrong please

 

[vbaInet]

The function you need is listed on the site I gave you. Have a look again.

 

[dsthome]

Sorry grey cells have kicked into life I have done it now thanks

 

[vbaInet]

Good job!

There's another function called Format() and it will give you the weekday name in one go. Look at the Format() function for Dates.