Hello,

using dbCalendar in Tornado EP. Couldn't format date in German dd.mm.yyyy. No Properties at dbcalendar are functional. All Tests with Options doesn't affect.

Below Code used

<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim XL As New Tornado.Z()
With XL
.dbQP = "S=10|M=G!sys=t!Rowedit=t|Ni=b5,Update,GridUpdate, Add,GridAdd,Delete,search|egu=t|ega=t|Th=Ti=Bearbe itung Wochenendarbeitsanmeldungen"
.dbUnit = "29"
.dbMode="Ty=Grid|sysindex=false|Indexfld=0"
.dbSuppressMsg = True
.dbPageSize = 100
.dbProvider = "ODBC"
.dbDSN = "DSN=mysqlmeister"
.dbDBType = "MYSQL"
.dbSQL = "SELECT * FROM uebantrag"
.dbSQLDateFormat = "yyyy-MM-dd"
.dbEditDateFormat = "yyyy-MM-dd"
.dbCalendar = "Mask=yyyy-MM-dd| IsUSADateFormat=False"
.dbBookMark = "uebantrag;lfd"
.dbGridDisplayFlds= "0,1,2,3,4,5,6,7,8,9"
.dbSkin = 25
.dbEditUpdateFlds = "0,1,2,3,fi=Arbeitstag|ty=TextCalendar,5,6,7,9,fi= lfd|ty=RNOUPDATE"
.dbBoolText = "DisplayTrue=Ja|DisplayFalse=Nein"
.dbMagicCell = "fi=Arbeitstag|mac=#Arbeitstag::dd.MMM.yyyy#,fi=Vo rarbeit|mac=(#Vorarbeit#|EQ|0||nein~|EL|||ja)"
.dbDebug = "FilterSetup, FilterAction, EditSetup, EditAction, ActiveSQL, Fields, Request"
.ASPdbNET()
End With
End Sub
</script>

That is the last code tested. Have tested many more options and syntax. Nothing runs on dbcalendar.

Writing date in correct format for mysql yyyy-mm-dd in field Arbeitstag all ok an ist saved good. But I need to input as dd.mm.yyyy or get this format from dbcalendar.

Please help.

Hartmut Rudorf