date format

[brh01]

hi, hope someone can set me straight. I want my date field to read...tuesday 11/30/2004... and I'm using the code...=format(Date(), "dddd, mm/dd/yyyy")...

I've tried this code in the format control ande default value control of my date field, without luck.

can someone please explain to me what I'm doing wrong.

Brian

 

[PHV]

Simply "dddd, mm/dd/yyyy" in the Format property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Gnism]

Try this: =Format(Date(),"dddd"", ""mm/dd/yyyy")

 

[brh01]

thanks to both of you , I've tried gnism's method and get an error.

phv, i've tried that too, and just tried again, for some reason the field goes blank as soon as i type that into the format box. and the date reappears when I delete the code(just not the date format i want).

Brian

 

[GingerR]

Both PHV's and Gnism's work for me.

so does this which isn't as cool: Format(Date(),"dddd") & " " & Format(Date(),"mm/dd/yy")