Dates

I have a text box that I have specified the "DateFormat" in as yyyy-mm-dd. When I retrieve the date from my system it still shows up in the text box as mm/dd/yy (which I think is the default). Does anyone know of a way to convert to an ISO (yyyy-mm-dd) date?

Dim Today as Variant
Today = date
txtDateFrom.Text = Today
txtdateTo.Text = Today



Thanks

Try changign the default Date in THe Control Panel.It should work as long as the Program is on ur System .But when you distribute it then that is another case

you can use the format function
Try

debug.print Format(date(),"yyyy-mm-dd")




RK