PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → [WB 19]Date format in tables
[WB 19]Date format in tables
Débuté par Nimesh, 04 aoû. 2015 07:24 - 9 réponses
Posté le 04 août 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]
Posté le 04 août 2015 - 07:29
how do you receive the dates?
:cool:
Posté le 04 août 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.
Posté le 04 août 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
Posté le 05 août 2015 - 09:01
Both are in DDMMYYYY format.:confused:
Posté le 05 août 2015 - 09:34
Can you show the code of filling the table
Posté le 05 août 2015 - 09:52
Hi

Always save dates like YYYYMMDD saves a lot of these issues.

regards
Allard
Posté le 05 août 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.
Posté le 06 août 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]
Posté le 07 août 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.