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?

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Bernie Yaeger" <(E-Mail Removed)> wrote in message
news:O$MmppE#(E-Mail Removed)...
> 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
>
>

Hi Bill,

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

Thanks for your help.

Bernie

"W.G. Ryan eMVP" <(E-Mail Removed)> wrote in message
news:ObH%23LFG%(E-Mail Removed)...
> 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?
>
> --
> W.G. Ryan MVP (Windows Embedded)
>
> TiBA Solutions
> www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> "Bernie Yaeger" <(E-Mail Removed)> wrote in message
> news:O$MmppE#(E-Mail Removed)...
>> 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
>>
>>
>
>

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.

--
Dave Fancher
http://davefancher.blogspot.com


"Bernie Yaeger" <(E-Mail Removed)> wrote in message
news:O$MmppE%(E-Mail Removed)...
> 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
>
>

Hi Dave,

Tx for the info - I'll give it a try.

Bernie

"Dave Fancher" <(E-Mail Removed)> wrote in message
news:ffOdnT2VlYBxK3ncRVn-(E-Mail Removed)...
> 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.
>
> --
> Dave Fancher
> http://davefancher.blogspot.com
>
>
> "Bernie Yaeger" <(E-Mail Removed)> wrote in message
> news:O$MmppE%(E-Mail Removed)...
>> 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
>>
>>
>
>