My need my date field to be saved in the database like dd/mm/yy how can i for text field to mask -/-/-/ALternatively how can i make my date column save date in my prefered format . i.e dd/mm/yy. pls note that i am using DATE data type
What database are you using? Are you sure the date in database is saved as dd/mm/yyyy instead of yyyy-mm-dd ?
You don’t save the date separator in the database, you just use the locale setting to format the date value. See Tools → Locale Settings in the help file.If you meant masked input, see https://www.hkvforums.com/viewtopic.php?f=4&t=28486.
gr8@ Thank you