10-26-2011 03:28 PM
Hello, all!
I have a vi that I run to record pressure on test units. I want to create a new excel report on the 1st day of each month. If it is not the 1st day of the month I want to just add the data for each test unit as a new worksheet. I have looked around and can't find a post for what I need to do exactly. If anyone can help, greatly appreciate.
10-26-2011 04:51 PM - edited 10-26-2011 04:52 PM
I would use the Seconds to Date/Time iv then check the month to see if it changed and/or check the day of month and see if it =1 then make a new file or wirte to the old file acordingly
10-27-2011 11:07 AM
Hey END82,
I agree with RTSLVU's suggestion of using the Seconds to Date/Time vi. From there you can wire the day of the month into a case structure, and have the case for day number 1 to be where you create a new excel report and have the other default case add the data to the report.
I attached a VI Snippet which you can drag onto a block diagram to look at.
Hope this helps!
Joe S
Applications Engineer
National Instruments