Dispaying a date with the day in

[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

But i would like it to dispay it in the following formate

From Friday 13 April 2007 to Thursday 19th April

If any one could help me that would be great

Thanks

 

[Jeff Boyce]

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

But i would like it to dispay it in the following formate

From Friday 13 April 2007 to Thursday 19th April

If any one could help me that would be great

Thanks

 

[i_takeuti]

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

But i would like it to dispay it in the following formate

From Friday 13 April 2007 to Thursday 19th April

If any one could help me that would be great

Thanks