Text box to display week commencing date?

K

KLR

I have created a report which contains an unbound text box in the
report header. This text box will need to display the week commencing
date for that week (Monday), e.g. if I run the report now, 27.02.06
will be displayed in the text box.

Only trouble is I don't know how to do this - am slowly getting my head

round Date function in Access but this one has baffled me. Can someone

help?
 
G

Guest

You're going to want something like this:

Me.txtCommenceDate = (txtReportRunDate - (Weekday(Me.txtReportRunDate,
vbMonday) -1))

The Weekday returns a number, then you are simply subtracting 1 less than
that number from today's date to get Monday's date.

HTH

Sharkbyte
 

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

week commencing date 1
Week commencing date reporting 1
Get date for start of week 3
Date Range on Report 6
Report Help 1
Week number from date 3
displaying Mondays date (week commencing) 0
Passing data to an unbound text box in a report 2

Top