I have developed a package in VB6 and backend MS Access. I have developed the package under system date format “MM/dd/yyyy” so my package is dependent on that system date format. The problem is if any machine has different system date format then package will give wrong transactions. So I am trying to crack that problem and for that I need some help.
My idea is when my package will open it will store the current system dateformat and will set the system dateformat to “MM/dd/yyyy” and when
thepackage will shutdown it will revert back the system date format what it was previously.
Can you tell me from VB how can I change SYSTEM DATE FORMAT. (Using which activeX and how).
I badly need this solution very soon.