LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

creating new report 1st day of each month

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.

0 Kudos
Message 1 of 3
(2,333 Views)

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

========================
=== Engineer Ambiguously ===
========================
Message 2 of 3
(2,326 Views)

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

 

0 Kudos
Message 3 of 3
(2,305 Views)