What to use in Custom SQL field:
DAY(DATEADD(mm,DATEDIFF(mm, -1, [Table: Field Date]),0) -1)
Example:
where [Table: Field Date] = [Assignment: Start Date]
Custom SQL fields - Command to display the number of days in the month of a certain date
What to use in Custom SQL field: DAY(DATEADD(mm,DATEDIFF(mm, -1, [Table: Field Date]),0) -1) Example: where [Table: Field Date] = [Assignment: Start Date]
Updated over 2 weeks ago