Grid not displaying the date format that I would like

Applications Grid / Reports
#1

Hello

I have a problem that the grid is presenting yyyy-mm-dd of a field while I want dd-mm-yyyy.
Appreciate some help as I run out of options.
I have 2 grids working one op a UNION of 2 tables and one on one table whic is part of the union all with a field start_date with type DATE.
The MYSQL statement works fine in phpmyadmin.

The grid field has format ddmmyyy and internal format YYYYMMDD and regional setting is on. (also try to change to my own settings but not sokvng the problem)

One grid with the same setting is presenting like I want with the same settings.
The grid that is wrong shows in Application/Fields [TABLE=“class: nmTable, border: 0, cellpadding: 0, cellspacing: 0”]
[TR=“class: nmLineV3”]
[TD]Type in Scriptcase[/TD]
[TD] [/TD]
[TD]DATA[/TD]
[/TR]
[TR=“class: nmTableLine”]
[TD=“colspan: 3”][IMG2=JSON]{“data-align”:“none”,“data-size”:“full”,“src”:“http://127.0.0.1:8090/scriptcase/devel/conf/scriptcase/img/btnnew/crystal/nm_transparent.gif”}[/IMG2][/TD]
[/TR]
[TR=“class: nmLineV3”]
[TD]SQL Type[/TD]
[TD] [/TD]
[TD]NEWDATE[/TD]
[/TR]
[TR=“class: nmTableLine”]
[TD=“colspan: 3”][IMG2=JSON]{“data-align”:“none”,“data-size”:“full”,“src”:“http://127.0.0.1:8090/scriptcase/devel/conf/scriptcase/img/btnnew/crystal/nm_transparent.gif”}[/IMG2][/TD]
[/TR]
[TR=“class: nmLineV3”]
[TD]Type Html[/TD]
[TD] [/TD]
[TD]TEXT[/TD]
[/TR]
[/TABLE]
The other grid which is working fine shows: [TABLE=“class: nmTable, border: 0, cellpadding: 0, cellspacing: 0”]
[TR=“class: nmLineV3”]
[TD]Type in Scriptcase[/TD]
[TD]DATA[/TD]
[/TR]
[TR=“class: nmTableLine”]
[TD=“colspan: 3”][IMG2=JSON]{“data-align”:“none”,“data-size”:“full”,“src”:“http://127.0.0.1:8090/scriptcase/devel/conf/scriptcase/img/btnnew/crystal/nm_transparent.gif”}[/IMG2][/TD]
[/TR]
[TR=“class: nmLineV3”]
[TD]SQL Type[/TD]
[TD] [/TD]
[TD]DATE[/TD]
[/TR]
[TR=“class: nmTableLine”]
[TD=“colspan: 3”][IMG2=JSON]{“data-align”:“none”,“data-size”:“full”,“src”:“http://127.0.0.1:8090/scriptcase/devel/conf/scriptcase/img/btnnew/crystal/nm_transparent.gif”}[/IMG2][/TD]
[/TR]
[TR=“class: nmLineV3”]
[TD]Type Html[/TD]
[TD] [/TD]
[TD]TEXT[/TD]
[/TR]
[/TABLE]
2 question :
Why is it not showing the right format and how to fix it ?
What is SQL type NEWDATE ?

#2

Are you using MYSQL?

what is de sql string you are using?

#3

I am using MYSQL
2 tables with similar structure. Start_date have bot date as type

MYSQL statement: Select empl_id, start_date from table1 UNION ALL SELECT empl_id, start_date from table2

#4

a workaround be to format the datefields already in the sql

try this to do so

SELECT
   DatumVluchtTransitBestemming,
   DATE_FORMAT( DatumVluchtTransitBestemming , '%d/%m/%Y')  AS datum
FROM
   tblPoging
1 Like
#5

Dear Mike,
Thanks solved it
but is ofcourse a workaround. Do not get why it makes internal as type NEWDATE.

#6

no problem

dont know what type NEWDATE is