the function month_start_date” is working for some dates and not for others
Please check this screenshot
null value for this
and has value for this
Hi @andyasne,
The first function tries to convert from Gregorian to Ethiopian date and the date "2022-11-09" in Gregorian is converted to the date "2015-02-30" in Ethiopian calendar.
The expression "month_start_date" expects a valid Gregorian date and the date "2015-02-30" is not considered a valid date in Gregorian Calendar.
My suggestion is to use a conditional expression to filter out those edge cases (13th month and the dates after the 27 for February) before finding the month_start_date.
1 Like
Thank you @neidy , I always thought month_start_date also works for Ethiopian calendar.