Appending Now() in a short format

[DC27]

I'm appending a date to a table, with the format Now()

Which is great as it gives me the date and time - thing is, i just want the date (not the hours, minutes) etc

I have tried chaning the format property of this field to "short date", but no joy there.

Any suggestions?
David

 

[vbaInet]

Lookup the Format() function. This is what you need

 

[DCrake]

Then do not use the Now() command use the Date() command

David

 

[DC27]

date() has done it - many thanks
David