| |
| Publicado el 04,agosto 2015 - 07:24 |
Hi All,
I am developing a site in which i need to display issue date and expiry date in table but date is not showing in proper format.
Attached screenshot for your ready reference. Kindly suggest
[attachment 1625 dateformat.jpg] |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,agosto 2015 - 07:29 |
how do you receive the dates?
:cool: |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,agosto 2015 - 07:42 |
| I input date into form in ddmmyyyy format but when i view the details into table it shows this type of value. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,agosto 2015 - 09:32 |
I think that you hjabe to check the inputmaks in the table
it seems to me that the table has mask YYYMMDD and you provide ddmmyyyy |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,agosto 2015 - 09:01 |
| Both are in DDMMYYYY format.:confused: |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,agosto 2015 - 09:34 |
| Can you show the code of filling the table |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,agosto 2015 - 09:52 |
Hi
Always save dates like YYYYMMDD saves a lot of these issues.
regards
Allard |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,agosto 2015 - 10:08 |
Nimesh
How you set the input mask will have no effect on how the DB stores the date.
Check your data - If you are using HF this will be stored as 'yyyymmdd'
In the table set the input masks for the column as 'DDMMYYYY' or however you wish.
Set the 'returned value' to match the stored format. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 06,agosto 2015 - 08:01 |
Hi All,
Thanks for your suggestions as i am providing the input mask in ddmmyyyy and returning value in yyyymmdd. I am attaching the screenshots of code and description for better understanding.
Regards,
Nimesh
[attachment 1629 description.jpg] |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,agosto 2015 - 16:43 |
Hi
You don't need any code.
You just need to setup properties with correct value.
For any field, you can setup 'Return Value', and 'format'. For format, and for your tests, use something like YYYY MMMM DD DDD (2015 AUGUST 07 Fri). It will help you to understand. |
| |
| |
| | | |
|
| | |