Insert/Update DateTime Record with now()
I am working on an employee time card website page. In DataAssist I am using 'Update Record Wizard'.
When an employee clicks on a Clock In page. The page list what their daily assignments are.
They then click a submit button and it trigger the 'Insert Record' behavior. This behavior inserts the records creating an ID and adding the employee name via a URL parameter. I also want to insert 'now()' into a clockin field.
In the insert record wizard if I set the 'Value' (page 2) of the checkin field to 2010-11-5 it inserts it with no problems. If I set the the 'Value' of the checkin field to now() or current_date() it puts 0000-00-00 into the datetime field.
I want to repeat this process when they checkout using 'Update Record' wizard.
How do I configure DataAssist to insert the current_date() or now()???
Bob