extract a day from a long date notation (1 Viewer)

[cluster]

Got a problem,

I got a large database imported from excel with only days on saturday and wednesday. I made it in a long date notation in the hope i could filter it on wednesday or saturday, to no succes. I just want to get 2 seperate queries where i have one where only the wedsnesdays are shown and the other with only saturdays.
I tried with the weekday expression, but don't know what to fill in to the required 'date' part.
Tried many different ways, but i'm just starting to use expressions so it's sometimes difficult to get the expression right with [ ] and or ( ), # ,....

Many thx in advance for helping out

 

[oleronesoftwares]

criteria under the date field will be like

Weekday ( date_value, [firstdayofweek] )

MS Access: Weekday Function

This MSAccess tutorial explains how to use the Access Weekday function with syntax and examples. The Microsoft Access Weekday function returns a number representing the day of the week (a number from 1 to 7) given a date value.

www.techonthenet.com

The link above explains it in detail

 

[arnelgp]

to follow with post #2,
to get all records for wednesday:

select * from yourTable where Weekday([datefield], 1) = 4;

for saturday data:

select * from yourTable where Weekday([datefield], 1) = 7;

 

[cluster]

to follow with post #2,
to get all records for wednesday:

select * from yourTable where Weekday([datefield], 1) = 4;

for saturday data:

select * from yourTable where Weekday([datefield], 1) = 7;

I do understand the numbering of the days in the week but I don't know what to add in that datefield.... just want all the dates filtered out.
Next is in that tutorial-link above they set an Expr1: Weekday(#12/03/2001#,1) in the field name? I can only choose between my fields that are in my query where i extract the data from.
thx

 

[cluster]

this is what I have now but get an error when activating it, it's in dutch... so sorry about that

 

[oleronesoftwares]

I do understand the numbering of the days in the week but I don't know what to add in that datefield.... just want all the dates filtered out.
Next is in that tutorial-link above they set an Expr1: Weekday(#12/03/2001#,1) in the field name? I can only choose between my fields that are in my query where i extract the data from.
thx

remove Expr1, remove the quote, use = signs instead

 

[oleronesoftwares]

This returns all thursdays.
5=thursday
4=wednesday

so in your case 4
then similar query you will use 7( for saturday)

 

[arnelgp]

for wednesday:

Veld: Expr: Weekday([Datum], 1)
Criteria: 4


for saturday:

Veld: Expr: Weekday([Datum], 1)
Criteria: 7

 

[cluster]

When i try to save this I get following error (ruffly translated: the syntaxis of this expression you specified is invalid

 

[cluster]

Finally got it the flaw was in the ' , ' behind [Datum] should be ' ; ' instead
FIELD: Weekday([Datum];1)
CRITERIA: 4

Thanks for the help!!! been searching for days!!!

 

[Gasman]

Finally got it the flaw was in the ' , ' behind [Datum] should be ' ; ' instead
FIELD: Weekday([Datum];1)
CRITERIA: 4

Thanks for the help!!! been searching for days!!!

Most people's separators are the comma ,, you just happen to use the semicolon ;
Make a note of this, as any other offerings for other questions will likely use the , not the ;