Date format with DBUtils

[TomDuncan]

Hi all,

I am using DBUtils to fill a listview

DateTime.DateFormat = "dd/MM/yyyy" 'set for Display
S= "SELECT [InvNbr] || ' ' || [DspName] || ' ' || InvDate FROM Invoice"

Dim PatInv As List
DBUtils.ExecuteListView(SQL1,S,Null,0,lvInv,False)
lvInv.SingleLineLayout.Label.TextSize=14

However the date comes out as "yyyy-MM-dd"
How can I change this?

Tom :sign0104:

 

[Erel]

DateTime.DateFormat doesn't have any effect on the values retrieved from the database. The date is saved in the database as a regular string.
You should use SQL date & time functions:

"SELECT ... || strftime('%d/%m/%Y', InvDate) FROM ..."