Analytics SAQL Reference
jNewer Version Available
Number 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('Close_Date_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('Close_Date_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('Close_Date_sec_epoch')) as 'Billing Days In Year;