Converting date formats within VBA

[paulwoods23]

I currently use a short date in UK format (dd/mm/yy) in a On Click event from a form to use in a query within some VB code. But this date is then used in US format (mm/dd/yy). How do I convert it back to UK format within the code so that the output is correct?
I tried the following to convert it -

Dim DateConv As Date
DateConv = Format(Me.SDate, "dd/MM/yy")

Then used DateConv instead of Me.Sdate.
But it didn't work. Any ideas?

 

[padinka]

OK, it seems to me that you need to format your output, not your input. You need to place your format code in your query, not in your input.
Trisha
padinka@yahoo.com

 

[paulwoods23]

I see what you mean, the query was reading a UK format as a US format so I needed to convert it to US format within the query.

I used
Format(Me.SDate, "mm dd yyyy&quot
and it worked a treat.

Thanks for the tip.