Dispaying date witht the day in

[Simon]

on my report i have the following code in a feild

="From " & [Startdate] & " to " & [enddate]

which dispays

From 13/04/2007 to 19/04/07

What i would like it to dispay is the following

From Friday 13 April 2007 to Thursday 19 April 2007

Any help would be great

Thanks

 

[fredg]

on my report i have the following code in a feild

="From " & [Startdate] & " to " & [enddate]

which dispays

From 13/04/2007 to 19/04/07

What i would like it to dispay is the following

From Friday 13 April 2007 to Thursday 19 April 2007

Any help would be great

Thanks

= "From " & Format([Startdate],"dddd dd mmmm yyyy") & " to " &
Format([enddate],"dddd dd mmmm yyyy")

 

[Guest]

try
="From " & format([startdate], "dddd d mmm yyyy") &" to " &format([enddate],
"dddd d mmm yyyy")

on my report i have the following code in a feild

="From " & [Startdate] & " to " & [enddate]

which dispays

From 13/04/2007 to 19/04/07

What i would like it to dispay is the following

From Friday 13 April 2007 to Thursday 19 April 2007

Any help would be great

Thanks

 

[i_takeuti]

on my report i have the following code in a feild

="From " & [Startdate] & " to " & [enddate]

which dispays

From 13/04/2007 to 19/04/07

What i would like it to dispay is the following

From Friday 13 April 2007 to Thursday 19 April 2007

Any help would be great

Thanks