date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell how to apply date format programmatically (dmy or mdy based
on the system setup) while opening a text file?

I need to apply this different format in OpenText method. It looks it needs
to be defined in the fieldinfo property, as one of these. My problem is how
do I find which date format is used in the system?

xlGeneralFormat General
xlTextFormat Text
xlMDYFormat MDY date
xlDMYFormat DMY date
xlYMDFormat YMD date
xlMYDFormat MYD date
xlDYMFormat DYM date
xlYDMFormat YDM date
xlEMDFormat EMD date
xlSkipColumn Skip Column
 
Can anyone tell how to apply date format programmatically (dmy or mdy based
on the system setup) while opening a text file?

I need to apply this different format in OpenText method. It looks it needs
to be defined in the fieldinfo property, as one of these. My problem is how
do I find which date format is used in the system?

xlGeneralFormat General
xlTextFormat Text
xlMDYFormat MDY date
xlDMYFormat DMY date
xlYMDFormat YMD date
xlMYDFormat MYD date
xlDYMFormat DYM date
xlYDMFormat YDM date
xlEMDFormat EMD date
xlSkipColumn Skip Column
Click to expand...

Look at the International Property.


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Small change needed in the below macro 0
how do i change text format date to date (i.e., mm/yy to mm/dd/yyy 1
Excel Addin altering date format on text file import 3
Why does the date toggle between formats 11
Refresh BackgroundQuery fails 3
How to force column formatting (text, date, etc) when loading a fixed width text file into an array? 3

Back
Top