days of week

[rob b]

How can I get a report to display the day of the week and the date ie. Monday 25 Jan etc.
Thanks in advance for any help.

 

[RedSkies]

In the fields properties, set Format to Long Date.

 

[rob b]

That just gives me 19 January 1999 I need it to say Monday 19/1/99

 

[DH]

Rob,

Try

dddd d/m/yy

The help files Format Property-Date/Time Data Type shows different examples.

David

[This message has been edited by DH (edited 05-09-2001).]

 

[Rich@ITTC]

Hi Rob

The Long Date format is dependent on the Windows settings within Control Panel->Regional Settings->Date. You could therefore make changes at this level, though it would also affect other programmes (such as any date fields you have in Word). Also if you use your database on another pc, the date format would reflect the settings for that machine.

If you want to maintain the format independently of the regional settings then use a custom format for that field:

dddd dd mmmm yyyy

gives you Monday 19 January 2001.

dddd dd mmm yyyy

gives you Monday 25 Jan 2001

dddd dd/mm/yy

gives you Monday 25/01/01

ddd d/m/yy

gives you Monday 25/1/01.


HTH

Rich Gorvin



[This message has been edited by Rich@ITTC (edited 05-09-2001).]