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
 
Back
Top