| Default value for a form item [message #80928] |
Sat, 14 December 2002 16:48  |
Robin Myaing
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
|
I have a Text item named Date on a form I have built. Please explain to me how I can have Sysdate as the default value for that item. I tried typing in Sysdate in the Default property for the item but I get an error message saying Format must be DD-MON-YY.
|
|
|
|
|
|
| Re: Default value for a form item [message #80954 is a reply to message #80928] |
Tue, 17 December 2002 05:09  |
Piyush Balan
Messages: 26
Registered: December 2002
|
Junior Member |
|
|
Hi Robin,
This is a common problem faced in Forms. for setting the default values as the system date, u have 2 options :
1. set the current date as the current date of the client which is running the form
2. set the current date as the current date of the Database.
for value 1, use $$DATETIME$$ in Default Value or Initial Value.
for value 2, use $$DBDATE$$ in Default Value or Initial Value.
this is the correct method to capture sysdate in Forms.
let me know if this doesn't help
Regards,
Piyush Balan
Consultant
Comsoft Pte Ltd
Singapore
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
