datepicker and dateformat

[Ward Germonpré]

Hi,

I have a datepicker on a form.
The selected date is stored in a table.
The format of that date field is 'short date notation'.

Unfortunately that doesn't work: both date AND time are stored.

I setup the datepicker object with dtpShortDate. This, combined with the
field format should yield a date only, no ?


thx for any help


Ward

 

[Guest]

HI Ward,

The date format you display has nothing to do with how the date is actually
stored in the database table. Simply format it the way you want it displayed
and let Access worry about how it's stored.


Hope that clarifies it for you.

Damian.

 

[Ward Germonpré]

Thx for replying Damian,


but that is exactly the problem.
This date is read from the database and diplayed in a listview object
first, and when the user clicks a button this date is then exported from
the database to a csv file, which means I have to intervene twice in vba
to format it to ddmmyyyy. I can manage that, but had hoped/expected
Access to do that for me.

Any suggestions ?

thx

Ward

 

[Ward Germonpré]

Weird, the problem is gone and i haven't done anything fundamental.
Must have been a glitch in access ?!


thx for anyone reading my post
regards

Ward

 

[Guest]

Hi Ward,

If for some reason you desperately need to store it in ddmmyyyy format, you
could store it in an 8 character text field like that. Of course, this won't
help you when you want dates for stuff... you would then need to convert it
back to a date.

Still, it's an option.

Damian.