Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
You can create it like this:
Floor(MonthEnd(FULL_DATE)) - Floor(MonthStart(FULL_DATE)) + 1 as DAYS
...or maybe
Day(MonthEnd(FULL_DATE))
Sample script:
Table:
LOAD Date(Date#(FULL_DATE, 'YYYYMMDD')) as FULL_DATE,
YEAR,
MONTH,
MONTH#,
DAY;
LOAD * INLINE [
FULL_DATE, YEAR, MONTH, MONTH#, DAY
20160301, 2016, Mar, 3, 1
20160302, 2016, Mar, 3, 2
20160303, 2016, Mar, 3, 3
20160304, 2016, Mar, 3, 4
20160305, 2016, Mar, 3, 5
20160306, 2016, Mar, 3, 6
20160307, 2016, Mar, 3, 7
20160308, 2016, Mar, 3, 8
20160309, 2016, Mar, 3, 9
20160310, 2016, Mar, 3, 10
20160311, 2016, Mar, 3, 11
20160312, 2016, Mar, 3, 12
20160313, 2016, Mar, 3, 13
20160314, 2016, Mar, 3, 14
20160315, 2016, Mar, 3, 15
20160316, 2016, Mar, 3, 16
20160317, 2016, Mar, 3, 17
20160318, 2016, Mar, 3, 18
20160319, 2016, Mar, 3, 19
20160320, 2016, Mar, 3, 20
20160321, 2016, Mar, 3, 21
20160322, 2016, Mar, 3, 22
20160323, 2016, Mar, 3, 23
20160324, 2016, Mar, 3, 24
20160325, 2016, Mar, 3, 25
20160326, 2016, Mar, 3, 26
20160327, 2016, Mar, 3, 27
20160328, 2016, Mar, 3, 28
20160329, 2016, Mar, 3, 29
20160330, 2016, Mar, 3, 30
20160331, 2016, Mar, 3, 31
20160401, 2016, Apr, 4, 1
20160402, 2016, Apr, 4, 2
20160403, 2016, Apr, 4, 3
20160404, 2016, Apr, 4, 4
20160405, 2016, Apr, 4, 5
20160406, 2016, Apr, 4, 6
20160407, 2016, Apr, 4, 7
20160408, 2016, Apr, 4, 8
20160409, 2016, Apr, 4, 9
20160410, 2016, Apr, 4, 10
20160411, 2016, Apr, 4, 11
20160412, 2016, Apr, 4, 12
20160413, 2016, Apr, 4, 13
20160414, 2016, Apr, 4, 14
20160415, 2016, Apr, 4, 15
20160416, 2016, Apr, 4, 16
20160417, 2016, Apr, 4, 17
20160418, 2016, Apr, 4, 18
20160419, 2016, Apr, 4, 19
20160420, 2016, Apr, 4, 20
20160421, 2016, Apr, 4, 21
20160422, 2016, Apr, 4, 22
20160423, 2016, Apr, 4, 23
20160424, 2016, Apr, 4, 24
20160425, 2016, Apr, 4, 25
20160426, 2016, Apr, 4, 26
20160427, 2016, Apr, 4, 27
20160428, 2016, Apr, 4, 28
];
DAYSMONTH:
LOAD FULL_DATE,
MonthName(FULL_DATE) as MONTHYEAR,
Floor(MonthEnd(FULL_DATE)) - Floor(MonthStart(FULL_DATE)) + 1 as DAYSMONTH
Resident Table;
Much more elegant