Timeofmonth spreedsheet trouble

[Nele09]

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

[Ryan.S]

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.

[Nele09]

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