date format using oledb provider and ms access in .net

  • Thread starter Thread starter Bernie Yaeger
  • Start date Start date
B

Bernie Yaeger

How can I select a date column in an Access table such that the select will
return a string in yyyymmdd format?

Thanks for any help.

Bernie Yaeger
 
It depends. You can "select" it formatted - or you can bind it formatted.
Is this solely a UI issue or do you need to true value returned?
 
Hi Bill,

Tx for the reply. I'm trying to 'select' it formatted.

Thanks for your help.

Bernie
 
You could use Access's Format function: Format(<field>, "yyyymmdd")
....but selecting the date in its native format and specifying a format when
it the value is actually used will provide you with more flexibility.
 
Back
Top