pcsoft.us.windevCopyright 2026, PC SOFT7 Aug 2015 16:43:18 Z4 Aug 2015 07:24:00 ZHi 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]30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)tbc92pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53468/read.awp7 Aug 2015 16:43:18 ZHi You don't need any code. You just need to setup properties with correct value. For any field, you can setup 'Return Value'…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53468/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53468/read.awp[WB 19]Date format in tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53440/read.awp6 Aug 2015 08:01:00 ZHi All, Thanks for your suggestions as i am providing the input mask in ddmmyyyy and returning value in yyyymmdd. I am attach…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53440/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53440/read.awp[WB 19]Date format in tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53423/read.awp5 Aug 2015 10:08:00 ZNimesh 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 t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53423/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53423/read.awp[WB 19]Date format in tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53422/read.awp5 Aug 2015 09:52:00 ZHi Always save dates like YYYYMMDD saves a lot of these issues. regards Allardhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53422/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53422/read.awp[WB 19]Date format in tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53421/read.awp5 Aug 2015 09:34:00 ZCan you show the code of filling the tablehttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53421/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53421/read.awp[WB 19]Date format in tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53418/read.awp5 Aug 2015 09:01:00 ZBoth are in DDMMYYYY format.:confused:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53418/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53418/read.awp[WB 19]Date format in tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53392/read.awp4 Aug 2015 09:32:00 ZI think that you hjabe to check the inputmaks in the table it seems to me that the table has mask YYYMMDD and you provide ddm…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53392/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53392/read.awp[WB 19]Date format in tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53391/read.awp4 Aug 2015 07:42:00 ZI input date into form in ddmmyyyy format but when i view the details into table it shows this type of value.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53391/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53391/read.awp[WB 19]Date format in tablesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53390/read.awp4 Aug 2015 07:29:00 Zhow do you receive the dates? :cool:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53390/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53388-19-date-format-tables-53390/read.awp[WB 19]Date format in tables