filter sundays

steve111

Registered User.
Local time
Today, 23:28
Joined
Jan 30, 2014
Messages
429
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
 
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
 

Users who are viewing this thread

Back
Top Bottom