Usually you can get this using LAST_DAY in esql but in app connect it's not working anyone has any idea on how to get last day of the month using esql in app connect?
1 Answers
I solved the problem I used intervals to get the next month then set the next month's date value to 1 and use interval again to get the day before, which will be the last date of the month in question. Basically I checked the next month and got next month's 1st date which will always be 1 then got the day before that which will always be the last date of current month.
Related