filter sundays (1 Viewer)

[steve111]

hi

I have a form that has a long date in it example

sunday, 06 March 2016

I want to be able to sort my query without sunday in it
I have tried the "left" function and the crtieria not "sunday" but neither work

any help appreciated
steve

 

[CJ_London]

dates are number - they are just presented as text.

investigate using the weekday function which returns a number for each weekday - the default for Sunday is 1, Monday 2 etc

 

[plog]

Use the WeekDay function (http://www.techonthenet.com/access/functions/date/weekday.php) on that field and then use that to filter out sundays.

 

[steve111]

thank you both
working great now
steve