Discussion Locked

Date format of VB and VFP

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am using VB6 to develop a program and using Visual FoxPro on Database. When i using sql to select data between two date( date format is DMY) in Visual FoxPro's command window .... the correct data can be load , but when i select data in VB6 the result of selection is wrong..... the date selected by program become MDY..... Can you tell how am i going to do with this problem??? the date format that i am using is DMY ...... Thank you very much.......

Pooi San

5 replies

by donq

Evidently your computer's Operating System software is set to displat Date/Time data types in the European Format. Change the setting to Americal Format.

My Computer | Control Options | Regional Options | Date (select M/d/yyyy)

by donq

for European countries set to dd-MMM-yy or dd-M-yyyy. (Your chouce usine a dash as the seperator). This affects all software.

by donq

for European countries set to dd-MMM-yy or dd-M-yyyy. (Your chouce usine a dash as the seperator). This affects all software.

This discussion is closed to new replies.