Field Format For A Date Using Now()

[Greg]

Hi Guys,

I've search the old posts and i can't seem to find what i'm looking for.

When i use Now() on Default Value in a field it correctly displays the date,
but a time as well.

Is it possible to just display dd/mm/yy only.

Greg.

 

[Keith Wilby]

Hi Guys,

I've search the old posts and i can't seem to find what i'm looking for.

When i use Now() on Default Value in a field it correctly displays the
date,
but a time as well.

Is it possible to just display dd/mm/yy only.

Greg.

Date()

Keith.
www.keithwilby.com

 

[Greg]

Duh !

Thanks Keith, i thought it would be simple.

Greg.

 

[Keith Wilby]

Duh !

Thanks Keith, i thought it would be simple.

Greg.

Don't worry Greg, we all get those "duh" moments.

Keith.

 

[fredg]

Date()

Keith.
www.keithwilby.com

If you do not need the time value use Date() instead of Now().
But either way, you can format the value using:
dd/mm/yy
in the control's Format property.