type conversion issue (access 2003)

Topic

New Reply

Post deleted by gbanks

Reply | Quote

Replies

You should specify YMD instead of YDM as date order.

Reply | Quote

Sorry Hans I mistyped in my posting. I am using YDM not YMD. Can you still adivse? Thanks….

Reply | Quote

The import specification in your database has YDM. As I wrote, you should use YMD. The dates will then import correctly – at least they did for me.

Reply | Quote

In addition, see the annotated screenshot below. The date order should be changed from YDM (the current setting) to YMD.

Reply | Quote

Thanks Hans. I got it now. A new morning breads a clearer mind.

Reply | Quote

Hans,
What program do you use for your annotations? I always seem to fumble around when I try annotating screen shots; I use Word but not very effectively.

Reply | Quote

This one was done in good old Microsoft Paint.
Many screen capture programs have an option to annotate screenshots; I use FastStone Screen Capture ($19.95) but there are also free utilities – see for example the thread in Other Software Applications starting at post 595,580.

Reply | Quote

Thanks, I’ll take a look at these.

Reply | Quote