09-28-2010 02:35 AM
Hi all
I got this problem with spreadsheet in lk6.1.
I've created spreadsheet which logs values to csv, normally.
I need to log these values only at the last day of month, or last hour at current month, only once.
I tried using timeofmonth timer so that I could use "Log Now" option in spreadsheet but it won't work.
Example:
Log now = if(Timer1<=00:00:59,ON,OFF)
Timer1 is timeofmonth countdown, 'till 00:00:00 ?
Is there option to check LastDayOfMonth or something like this, so I can trigger this logging on??
Thanks
09-29-2010 08:57 PM
The Timer1 is not the countdown value. It is ON or OFF of the timer.
So, if you set Log Now = Timer1, it will log at the end of the month. But I'm not sure if the timestamp will be the end of the month or the begin of next month.
10-01-2010 02:52 AM
Hi Ryan
I've tried that.. but it trigerrs logging and creats csv for next month..
Is there any option inside LK6.1 that can check last-day-of-month so that I can trigger one-time loging?
Thanks