| CHANGING DATE FORMAT IN FORMS [message #224740] |
Thu, 15 March 2007 05:15  |
ataufique
Messages: 79
Registered: November 2006
|
Member |
|
|
I have change the date format in my database from DD-MON-YYYY
to DD/MM/YY.
But my forms are still showing old format,
Now where can i change in Forms setting such that it show new date format.
One way I found is format mask of each item, But this is not a
Global way.
IF any one knows, pls suggest how this can be done globally without changing in each and every forms.
Regards
Taufique A.
|
|
|
|
|
|
| Re: CHANGING DATE FORMAT IN FORMS [message #225158 is a reply to message #225124] |
Sun, 18 March 2007 10:29  |
 |
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
|
Senior Member |
|
|
| Quote: |
I have change the date format in my database from DD-MON-YYYY
to DD/MM/YY.
|
I think you can't change the date format in database such that it can be reflected in forms.
You'll have to change it in forms. You can use property Class feature in forms to make your changes in the form globally. But again for this purpose, you'll have to open the forms.
You can create one form and create a date item. Create a Property Class in that form and set the format mask of date item. Apply that property class to the item.
Now, open your forms where you want to set the format mask. Open Properties of the date item and Open Subclass Information. Select the form here you already created and select the property class. The format mask will be inheritted from that form's item which you created before.
You can assign this property to all your date items in your form.
I don't know any other way to set the format mask globally. May be someone will help if there is any other solution.
regards,
Saadat Ahmad
[Updated on: Sun, 18 March 2007 10:32] Report message to a moderator |
|
|
|
|
|
| Re: CHANGING DATE FORMAT IN FORMS [message #225973 is a reply to message #225672] |
Thu, 22 March 2007 02:39 |
ataufique
Messages: 79
Registered: November 2006
|
Member |
|
|
Hi martin,
No this is not yet solved...
Better way till now what i found is go to the property of
date item and set format mask(one step), rather then what saadat suggested (create property class, open date item property and attach).
But what i am looking for is a global way as the above is not the better way to change in 42 forms(with an avg of 2 date items in each form).
Anyway thanks both for the help, I am using Forms 10g on 9i database, Windows platform.
Hope fully this could be considered in future version of Forms..
Pls suggest if there is any other solution to this.
Thanks & Regards,
Taufique Ahmed.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
