08-20-2013 02:03 PM
I have a 2 dimensional string array where the second column of data contains dates. I want to change the date data from day month year to year month day. How can I do this?
08-20-2013 02:20 PM
Index out the column
Format to timestamp
format back to string
replace column
08-20-2013 02:27 PM
Thank you. I was too general on the description of the date format
Current date field example: 05 Feb 2012
Replaced date field example: 2012 02 05
Does your example address this format?
08-20-2013 02:34 PM - edited 08-20-2013 02:40 PM
not exactly but a minor mod to the format specifiers would
That does it
08-20-2013 02:40 PM
Would you mind posting the vi, as the functions are not immediately familiar?
Thank you
08-20-2013 02:41 PM
Check the edit above. It took a minute
08-20-2013 02:48 PM
Harry,
Jeff's picture is a code snippet. Drag the picture to your desktop and then drag it into a VI. Voila.
08-20-2013 02:53 PM
That is cool. Thanks!!!
08-20-2013 02:53 PM
@aputman wrote:
Harry,
Jeff's picture is a code snippet. Drag the picture to your desktop and then drag it into a VI. Voila.
If you look at the edit time in the post it makes more sense. I posted- ran off to whip up a quick example (Couldn't remember the difference between %B and %b) and was delayed with the edit crossing Harry's post- so there was no example when he read it the first time.
(These things sometimes just need to be explained to make any sense)
08-20-2013 02:56 PM
@Harry_Sundberg wrote:
That is cool. Thanks!!!
Welcome, Next thing you know you'll be giving Kudos and marking solutions