Dates

[Chris B.]

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

[chem1]

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

[Ravi Kiran]

you can use the format function
Try

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




RK