[WD18] Table Column Date format problem ?

Startbeitrag von Danny Lauwers am 13.05.2013 15:30

Hi All,

I have a table column linked to a Date variable and the date is showing, but in the wrong format.

It is displayed in MM/DD/YY instead of the projects DD/MM/YY setting.
I also tried to configure the Column to use not the project settings but fixed DD/MM/YY but stil the column is not displayed in the correct fomat.

Could this be a bug ?



try changing the format by programing with DateToString() function
in the rowdisplay code

i dont know if is such code area in WD


von Cesar Flores - am 13.05.2013 18:27
Hi Danny

most of the time, problem in date formatting is coming from the fact that you are not using the proper format in the TWO DIFFERENT SETTINGS...

Your display format should be what you want to see (by example DD/MM/YYYY) but the RETURNED VALUE format should be YYYYMMDD (basically each and every time, as this is THE way in which date are stored in a DB)

Best regards

von Fabrice Harari - am 13.05.2013 18:52

Re: [WD18] Table Column Date format problem ? [SOLVED]

Sorry, my mistake. It was not a problem with the formating in the table, that works correctly. I had made a mistake in parsing external data.

Thanks for your replies !

von Danny Lauwers - am 14.05.2013 08:58
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.