Is there any function available in Optic API to identify last day of a month?
I have requirement to identify a date whether its last day of a month or not.
Is there any function available in Optic API to identify last day of a month?
I have requirement to identify a date whether its last day of a month or not.
Copyright © 2021 Jogjafile Inc.
I suggest adding one day to the date/dateTime, and then seeing if the month has changed using
sql.month()
, ie: