06-16-2021 4:44 PM
i need to retrieve the current month data
i used the below query
DAYSOFMONTH ((T1."U_ARDate") = MONTH (CURRENT_DATE))
but doesn't work
Thank you in advance
06-16-2021 7:01 PM
Hi,
What are you trying to achieve? Current month number? Or the number of days in current month?