| Date field Entry/Convertion in forms [message #82708] |
Wed, 25 June 2003 03:13  |
Nitin Bane
Messages: 10
Registered: March 2003
|
Junior Member |
|
|
I maintain list of possible date formats in database table.
Example.
dd
ddmm
ddmmrr
dd/mm
dd/mm/rr
dd/mm/rrrr, etc
In Forms, User can enter the date in any of the above formats. I want to convert this entry into date by appending appropriate month and year of current date if required. Above mentioned task can be achieve by having 2 field (character type for data entry and date type for storage).But I want to use only 1 date type field.
Is there any ready made function available for the above mentioned task?
Please guide me.
Thanks
NITIN BANE
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
