Determining the day of the week far into the future.

F

Frank Martin

I have Access2003 and a form to book future dates.

The form is based on a query with the fields:
MessageID,
TodaysDate,
MessageDate,
Time,
Message.

Is there an expression I can put into this query that will
find the day of the week for some booked event year (or so)
ahead?

Please help, Frank
 
F

Frank Martin

Many thanks - this worked brilliantly. I was lost in the
"WeekdayName Function".
Frank


message
Yes --
Future_Date: Format([BookedDate], "dddd")
--
KARL DEWEY
Build a little - Test a little


Frank Martin said:
I have Access2003 and a form to book future dates.

The form is based on a query with the fields:
MessageID,
TodaysDate,
MessageDate,
Time,
Message.

Is there an expression I can put into this query that
will
find the day of the week for some booked event year (or
so)
ahead?

Please help, Frank
Click to expand...
Click to expand...
 

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

calculate a future date 2
Main form- subform for -logging hours worked for day/week 2
Rogue future date field highlighting 3
Hide Columns in a datasheet Subform based on a another field value 1
Update table with future date calculated in form 6
Dlookup - double booking 4
subform within subform On Main for Child master link question 2
Searching/Filtering Form by Date Calendar: Week Beginning... 1

Top