Setting Month as Interval

[abdullah123456789]

Hello, I have some data in Geo Scada and this data is progressing cumulatively. I also save the data to the Geo Scada database once a day. While saving them to the database, I need to be able to show the difference between the first day of the month and the last day in order to observe their change.

For example, there are 30 data I received in the range of 1-30 April. These 30 values are saved in the database and I can see it as a historic list. In order to see the monthly change, I can calculate the monthly value change for April by subtracting the value on April 1 from the value on April 30. But Second, Minute, Hour, Day and Week options are available as Interval in Calculation functions. I can choose 30 Days or 4 Weeks as the interval, but there is no 1 Month option. This will cause the calculations to be made for months with 31 days or in February, which has 28 days, to be wrong. Isn't there a way to enable the Month option for Interval in Calculation functions? Or is there an alternative way to solve this situation?

[geoffpatton]

I don't remember where of for what I have done this but I have taken the value at midnight on the 1st and used that as the value for end of the month.