Date formats

[s.booth]

Trying to pass a date to an empty field on a form when a completed check boc is ticked. I am using

Me.completedon = Now()

but I also get the time, how can I pass just the date???

Thanks

 

[fuzzygeek]

now is not the date

Use the date function instead

<variable> = Date

This gives the date only

 

[s.booth]

Cheers, Thats done the trick.