date format in grid

[fdb]

I have a grid in a dialog, related to a database.
The grid has several columns, of which one is a date.
Data is writte from a basic macro, having the date in ‘standard’ format.
But I want this dates in dd/mm/yyyy format and I cannot find any examples on the net.

I have a grid in a dialog, related to a database.
The grid has several columns, of which one is a date.
Data is writte from a basic macro, having the date in ‘standard’ format.
But I want this dates in dd/mm/yyyy format and I cannot find any examples on the net.

dim date as object ’ “com.sun.star.util.Date”
dim date1

date1.Year = 1999
date1.Month = 12
date1.Day = 22
date = date1

hDialog = CreateUnoDialog(DialogLibraries.getByName(“MyLibrary”).getByName(“MyDialog”))
hEventTable = hDialog.getControl (“EventTable”)

hColumn1 = makeColumn (hEventTable, “Datum”, 50)
hColumn2 = makeColumn (hEventTable, “Remark”, 120)

’ this will show the date as mm/dd/yy, I want dd/mm/yyyy
hEventTable.Model.GridDataModel.addRow ("",array ("date, “blablabla”))

hDialog.execute ()

Any help ?
advTHANKSance

[RobertG]

I would take the data and set it to text-content. Don’t see any possibility to set a special format in grid of a dialog.
From a database the date will have format YYYY-MM-DD by default.
But: If you format a data in another way the grid couldn’t be sorted by date - only by the string.
Might help also: Have a look at the language of GUI and the format of date…