hello,
i need get the field-date in specific format by sql in the vb
i know it something as dateformat but i didn't know
how i do it.
can somebody help ?
thanks

There's heaps of different ways you can format dates, whether it be through the format expression - eg: Format([FieldName],'Medium Date')

or whether you extract parts of the date and then re-arrange them
eg:

DatePart('yyyy',FieldName) & "/" & DatePart('m',FieldName) & "/" & DatePart('d',FieldName)

You can even combine them, such as:

UCase(Left(Format([FieldName],'Medium Date'),7)) & DatePart('yyyy',[FieldName])

If you want your medium date to be 01-NOV-1998 rather than 01-Nov-98

All those examples work in both queries and VBA

If you're still unsure, let me know the exact format you want the date in, and I'll let you know how to format it.

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends