Querying certain days from a date 2

[techkenny1]

Hi all,
On a Continous form I have a date field. I want to know what to put on the criteria line of a query so that I can pull out days, Monday, Tuseday etc.
Many thanks,

kp

 

[PHV]

You may use Format([Date field],"dddd")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya techkenny1

Ad the following custom field to the query to view the day (shortform Mon-Tue-Wed ...):

[blue]WkDy:Format([Date field],"ddd")[/blue]

To filter using criteria:

[blue]Weekday([[b]YourDateFieldname[/b]])=[purple][b]Const[/b][/purple])[/blue]

Where [purple]Const[/purple] = 1 for Sunday, 2 for Monday ..., 7 for Saturday.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[techkenny1]

Thanks guys,
I can use both of these..
kp