Can i show the day in a report by using a date field

[Juddy58]

hello i have a report that has a date field im just wondering if there is a way i can use a function or something to show the particular day by calculating the date field
eg, the date field contains "16/03/2003" i need to show "Sunday" on the report by working it out from the date. 17/03/2003 would be "monday" and so on.
Any help would be appreciated.
Thanks!

 

[KenReay]

Hi

THE function WeekDay() will return a day number within the week from a date (eg 1-7), set up an array eg

Dim WDays(7) As String
Dim strDay as String
WDays(1) = "Sunday"
WDays(2) = "Monday"
..etc

strDay = WDays(WeekDate(YourDateField))
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[KenReay]

Hi
Sorry that line should read
strDay = WDays(WeekDay(YourDateField))
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[PaulBricker]

Format([DateField],"dddd&quot

That should do what you want.

Paul

 

[KenReay]

Hi Paul,

of course it will!! well done

talk about not seeing the wood for the trees sometimes!! Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[PaulBricker]

Yeah, we've all been on both sides of that forest.

Paul

 

[Juddy58]

Thanks fellas works perfectly!
Cheers!