Hi everybody,
In the Help to set date command I read:
AMERICAN mm/dd/yy
ANSI yy.mm.dd
BRITISH/FRENCH dd/mm/yy
GERMAN dd.mm.yy
ITALIAN dd-mm-yy
JAPAN yy/mm/dd
My question is: how can I get the format string and use it for InputMask? I guess, it's not that hard using CHRTRAN() function.
This seems to work:
CHRTRAN(TRANSFORM(DATETIME()),"1234567890","9999999999")
If it's not broken, fix it until it is.
My Blog