Android Question Teble Class Date Format

[Carlos Pizzi]

Hi there

I'm using "Class Table v1.33"

How do I show data "date" in the following format dd/mm/ yyyy ?

thank you very much

I have the following code

Sub Globals
    Dim TablePedidos As Table   
End Sub

Sub Activity_Create(FirstTime As Boolean)

    TablePedidos.Initialize(Me, "TablePedidos", 4, Gravity.CENTER_HORIZONTAL, True)
    TablePedidos.CellAlignment = Bit.OR(Gravity.LEFT, Gravity.CENTER_VERTICAL)
    TablePedidos.HeaderColor = Colors.Blue
    TablePedidos.HeaderTextColor = Colors.Yellow
    TablePedidos.TextColor = Colors.Blue
    TablePedidos.TableColor = Colors.Red
    TablePedidos.RowHeight = 50dip
    TablePedidos.AddToActivity(PanelTPCTabla, 0, 0, PanelTPCTabla.Width, PanelTPCTabla.Height)   
    TablePedidos.MultiSelect = False   
    TablePedidos.ClearAll
    TablePedidos.LineWidth = 3dip
    TablePedidos.TextSize = 20

    Dim tf() As Typeface
    tf = Array As Typeface(Typeface.DEFAULT, Typeface.DEFAULT_BOLD, Typeface.DEFAULT, Typeface.DEFAULT_BOLD, Typeface.DEFAULT)
    TablePedidos.SetTypeFaces(tf)


    Dim Query As String
    Query = "select pedidoscabecera.idtransaccion as ID, pedidoscabecera.date as Fecha, clientes.razonsocial as Cliente from pedidoscabecera inner join clientes on pedidoscabecera.idcliente=clientes.idcliente"
    TablePedidos.LoadSQLiteDB(Main.SQL1, Query, True)

End Sub

 

[sirjo66]

Try with
DateTime.DateFormat = "dd/MM/yyyy"
as first line

 

[klaus]

How are the dates saved in the database ?

 

[Carlos Pizzi]

SIRJO66
it did not work (to my knowledge)

KLAUS
First I add it in the table. After confirming, would record in the database


Thank you

 

[Mahares]

What Klaus is asking you is: What is the date format when saved to the database? Is it mmddyyyy, is it yyyymmdd, is it a long as ticks like: 134258947533, is it something else?