Hi, I want to load a listbox with the date that are stored in a database
(mdb), the problem is when I retrieve the date it has a format like
"01/01/2006 0.00.00". In Access the date is stored as short date.
Thanks in advice

Try this:

dim dtDate as date
dtDate = format(Cdate([AccessDateField]), "MM/dd/yyyy hh.mm.ss")

I'm not 100% sure about this, but even though Access date fields
display as shortdate, I believe the stored value also contains the
Time, and if that is the case, the above code will display what you
need. But if only the Date is stored then the Time stamp portion will
likely return only "12.00.00"

Good luck!


michele wrote:
> Hi, I want to load a listbox with the date that are stored in a database
> (mdb), the problem is when I retrieve the date it has a format like
> "01/01/2006 0.00.00". In Access the date is stored as short date.
> Thanks in advice

I try it and it works fine, thanks


"Jerry H." <(E-Mail Removed)> ha scritto nel messaggio
news:(E-Mail Removed)...
> Try this:
>
> dim dtDate as date
> dtDate = format(Cdate([AccessDateField]), "MM/dd/yyyy hh.mm.ss")
>
> I'm not 100% sure about this, but even though Access date fields
> display as shortdate, I believe the stored value also contains the
> Time, and if that is the case, the above code will display what you
> need. But if only the Date is stored then the Time stamp portion will
> likely return only "12.00.00"
>
> Good luck!
>
>
> michele wrote:
>> Hi, I want to load a listbox with the date that are stored in a database
>> (mdb), the problem is when I retrieve the date it has a format like
>> "01/01/2006 0.00.00". In Access the date is stored as short date.
>> Thanks in advice
>