Analytics SAQL Developer Guide
jNumber of Days in the Month, Quarter, or Year
Returns the number of days in the month, quarter, or year for the specified
date.
month_days(date)
Returns the
number of days in the month for the specified
date.
1q = foreach q generate month_days(toDate('CloseDate_sec_epoch')) as 'Billing Days In Month';quarter_days(date)
Returns the number
of days in the quarter for the specified date.
1q = foreach q generate quarter_days(toDate('CloseDate_sec_epoch')) as 'Billing Days In Quarter;year_days(date)
Returns the number of
days in the year for the specified date.
1q = foreach q generate year_days(toDate('CloseDate_sec_epoch')) as 'Billing Days In Year;