format date to dd/mm/yy regardless of windows settings

[222]

Hi all,

When I get the date data from database, I noticed that the date format is depends on the system date format. For example, if I set the date format (from Windows Regional Settings) to dd/mm/yy, the date that I get from database will be as 31/12/05.. If I set it to dd/mm/yyyy, it will display as 31/12/2005.. May I know how can I code my program to get the date format permanently as dd/mm/yy regardless of what kind of date format that the Windows system may have?

THANKS!!

[Khalid]

What database are you getting the date from?

-Khalid

[222]

Khalid

From Microsoft Access Database.... Any solution?

[TiTou]

Hi 222,

This is quite easy and well documented in the help topic...
If you use the "Format date/Time string" function,

to get 2005 => %Y
to get 05 => %y

see attached VI

[222]

Hi Titou

Ya.. I know that method of formatting date but my date data from the database are in String format... how can I format it into Time Stamp? Any advise?

[TiTou]

Woops... sorry I missed the point on the first shot

Well you said you are receiving a string that is either dd/mm/yy or dd/mm/yyyy depending on the computer settings, and waht you want it to always have dd/mm/yy, is that it ?

Then you can draw a function in a while loop that take the after string of a match pattern and link the "index found" to the stop and cut the yyyy to yy, like this :

Message Edité par TiTou le 02-22-2006 08:29 AM

[222]

Thank you so much.. Will try it out!!!

[222]

Hi Titou

Thanks for the example code.. But my date string is "31/12/2006 12:00:00 PM"... How can I get the time out and still will get 06 regardless of input of 2006 or 06...?

[tst]

What you may want to do to be safe is to modify the way in which the DB is outputting the date. For instance, if you're calling a built in query, you can right click the field in the design view and from the properties screen change the way it's formatted. The same thing can be done for tables. That way, no matter how the OS is set up, the DB will always return data in the same format.

[TiTou]

I have never used any DB in LabVIEW so I assume tst pointed the best solution.

If you still want to do it playing with the string, just add, before the string enters the loop, a  "match  pattern" the pattern being space and get the "before sub-string".