Subject Re: date settings From Mustansir Ghor <mustan31@hotmail.com> Date Fri, 01 Jan 2021 13:04:37 -0500 Newsgroups dbase.getting-started Dear Akshat Thank you. dtos() solved the problem. Regards Mustansir Akshat Kapoor Wrote: > 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