default sysdate

[Guest_imported]

I create a datefield on the database which takse date and time as values, like nov/30/2001 11:45pm.
However, I now need to make that a default whereby a user does not have to manually type in the date and time.
How can I do this?
I tried datefield := to_char(sysdate, 'mon/dd/yyyy HH24:MI)
I was trying to make this change on when-create-record trigger.
I am running into error message INVALID MONTH.
Any help would be greatly appreciated

 

[lewisp]

First, make sure you have the correct format mask defoned for your date field. Then, in the default value property of the field type $$DATETIME$$ or $$DBDATETIME$$.

$$DATETIME$$ gets the local system date and time and $$DBDATETIME$$ effectively reads SYSDATE from the DB.