Hello, I am looking how I can calculate the delta since the beginning of the year. I have already tried it with different variants (LocalDateTime, Eppoch etc.), but always despair at the OH3 Date Time Conversion.
val ZonedDateTime firstDayThisYear = now.withMonth(1).withDayOfMonth(1).withHour(0).withMinute(0).withSecond(0).withNano(0)
logInfo("TEST","Since " + firstDayThisYear + " Consumption: " +(VI_PowerConsumption_TV_Total.deltaSince(firstDayThisYear) as Number))
Given this error, you’ve got the ZonedDateTime stuff working just fine. The problem is the call to persistence. You could make the calculation of the first day of the year a little shorter but based on the log what you have there works.
Do you have data that goes back that far? For most of the databases, if there isn’t data around the time time you request it will return null. You can look at a chart or call historicState and see if it returns anything.
Yes you are right, the oldest data is from 20th January.
If I set firstDayThisYear to day 20, I get a value back. Is there a way that it just uses the oldest value if there is no data to 01.01?
