Calculated Date ....Help please

[ciskid]

Hi Folks

I have a simple table that has a date field.

This is called dateopened and is in the format ddmmyy hh:m

I have a query based on this table.

What I'm trying to do is workout the day that a case was opened from the date entered.

i.e I have an entry that was opened on 10/08/06

My calculated filed works out that this was raised on a Thursday ?

I can then do dcounts etc on how many cases were opened on a Thursday or a Friday etc

I cant really get my head around the syntax in the query fileld

Can anyone advise me how to do this ?

Many thanks

Jimmy

 

[Chrism2]

I'm seriously no expert, but here's how I'd tackle it - seeing as no-one else has replied.

Use the WEEKDAY function in an expression to extract the Day from your date. It will return an integer represtenting the day. 1=Sunday by default, etc.

When you use your query filter, run the filter by the integer.

With me?

 

[ColinEssex]

Or use the Format() function.

Format([YourDateField],"dddd")

Col

 

[ciskid]

Or use the Format() function.

Format([YourDateField],"dddd")

Col

Hey Guys

Many thanks, manage to sort it all out !

Now know how to use calculating fields in a query

Many thanks

Cheers

Jinmmy