working out the day from the date

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hiya,
Basically I have a table tblRubbishPickUp which records the weight of
rubbish picked up
on certain dates, the table has the fields (Weight, Date, Driver) I
want to be able to work
out the actual day i.e Monday, Tues, Wed etc does anyone know the
formulae
that you enter in to the query to figure this out?

Fie
 
WeekDayName(Weekday(Date),True) will return Wed
WeekDayName(Weekday(Date),False) will return Wednesday
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ordering 1
Excel Forecasting Dates Out to the Day 3
Need Query help!!!! 3
top 5 days for each user 12
working out the day 2
using Dates as a Criteria/Lookup in Query 2
MATCHING RECORDS BASED ON A RANGE OF DATA 3
How to write a query that add 1 working day to the date 2

Back
Top