Dispaying a date with the day in

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

On my report i have a field with with the following code
="From " & [Startdate] & " to " & [enddate]

which dispays the following
From 13/03/07 to 19/04/07
Click to expand...

But i would like it to dispay it in the following formate
From Friday 13 April 2007 to Thursday 19th April
Click to expand...

If any one could help me that would be great

Thanks
 
Take a look at Access HELP for the Format() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Simon said:
On my report i have a field with with the following code
="From " & [Startdate] & " to " & [enddate]

which dispays the following
From 13/03/07 to 19/04/07
Click to expand...

But i would like it to dispay it in the following formate
From Friday 13 April 2007 to Thursday 19th April
Click to expand...

If any one could help me that would be great

Thanks
Click to expand...
 
Simon said:
On my report i have a field with with the following code
="From " & [Startdate] & " to " & [enddate]

which dispays the following
From 13/03/07 to 19/04/07
Click to expand...

But i would like it to dispay it in the following formate
From Friday 13 April 2007 to Thursday 19th April
Click to expand...

If any one could help me that would be great

Thanks
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

Dispaying date witht the day in 3
MS-Access sum problem in query 2
Format the date to UK style 5
Extraction of Dates 4
I would like my textbox to display a diff colour!*010509 3
Deleting Maximum Values 2
Is there a way to find the date where a client's balance becomes morethan zero? 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Back
Top