Subject Re: date settings From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Fri, 1 Jan 2021 23:15:22 +0530 Newsgroups dbase.getting-started Good Evening Mustansir, > I have an entryfield set to blank date and on form open i assign to > current date. In the onchange event it gave followings results (At form > open date is set to british) > > ?this.value > 01/01/20201 > > set date to ymd > > ?this.value > 2006/07/14 > > How or what is the conversion formula here. Wy do you want to change the date. If you want to use the date as part of sql then there is a very easy option Try ?dtos(date()) Regards Akshat