Gebruik de mid-functie om het jaar, de maand en de dag te zoeken:

mid("","","") string, offset, n

jaar:

mid(format(GetValue("DATE"),"Date","dd.mm.yyyy", ),"6","4")

maand:

mid(format(GetValue("DATE"),"Date","dd.mm.yyyy", ),"3","2")

dagen:

mid(format(GetValue("DATE"),"Date","dd.mm.yyyy", ),"0","2")

Al het bovenstaande in een voorwaarde combineren:

mid(format(GetValue("DATE"),"Date","dd.mm.yyyy", ),"6","4")+"-"+

mid(format(GetValue("DATE"),"Date","dd.mm.yyyy", ),"3","2")+"-"+

mid(format(GetValue("DATE"),"Date","dd.mm.yyyy", ),"0","2")