default date value in datetime field

[QuintonV]

how do I get the curent date now() as a default value for a date field? I used timestamp and want it in the same formate ie. yyyy/mm/dd hh:mm:ss but need a static date that doesnt change for keeping track of when a record was created I tried puting date() in the default value field of the specific date field but it didnt work I also tried now()

Thanx in advance

Quinton

 

[smedvid]

Date() and Now() should both work to get a default date. Check the Format and Input Mask fields.

Format: mm/dd/yyyy (or yyyy/mm/dd)
Input Mask: 99/99/9999;0; (or 9999/99/99;0

You can expand these to include time if necessary..

Not sure based on info u provided... htwh Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/