This requires Builder privileges for utilization.
| Expression Returns | Syntax | Data Type |
Results Example |
| Calendar Year | YEAR(datetime_column) | INT | 2015 |
| Calendar Quarter | FORMAT(datetime_column,"q") | INT | 2 |
| Day of Year | DAY(datetime_column) | INT | 365 |
| Month Number | MONTH(datetime_column) | INT | 12 |
| Month Name | MONTHNAME(MONTH(datetime_column),FALSE) | STRING | February |
| Short Month Name | MONTHNAME(MONTH(datetime_column),TRUE) | STRING | Feb |
| First Day of Month | DATESERIAL(YEAR(datetime_column), MONTH(datetime_column), 1) | DateTime | 1/15/2015 |
| Week Number | FORMAT(datetime_column,"ww") | INT | 42 |
| Weekday Name | WEEKDAYNAME(WEEKDAY(datetime_column),FALSE) | STRING | Friday |
| Short Weekday Name | WEEKDAYNAME(WEEKDAY(datetime_column),TRUE) | STRING | Fri |
| Weekday Number | WEEKDAY(datetime_column) | INT | 5 |
| Day in Month Number | DATEPART("y",datetime_column) | INT | 25 |
| Boolean Weekend | IIF((WEEKDAY(datetime_column) = 1) OR (WEEKDAY(datetime_column) = 7), 1, 0) | INT |
1 = True 0 = False |
| Hour(s) in Day | HOUR(datetime_column) | INT | 13 |
| Minute(s) in Hour | MINUTE(datetime_column) | INT | 56 |
| Second(s) in Minute | SECOND(datetime_column) | INT | 42 |
| Fiscal Quarter (July - June) |
"FY"&(IIF(MONTH(datetime_column)>6,RIGHT(YEAR(datetime_column),2)+1, RIGHT(YEAR(datetime_column),2))&"-"&CHOOSE(MONTH(datetime_column),"Q3","Q3","Q3","Q4","Q4", "Q4","Q1","Q1","Q1","Q2","Q2","Q2")) | STRING | FY15-Q4 |
| Fiscal Quarter (October - September) |
"FY"&(IIF(MONTH(datetime_column)>9,RIGHT(YEAR(datetime_column),2)+1, RIGHT(YEAR(datetime_column),2))&"-"&CHOOSE(MONTH(datetime_column), "Q2","Q2","Q2","Q3","Q3","Q3","Q4","Q4","Q4","Q1","Q1","Q1")) | STRING | FY15-Q4 |
| Date Difference | datetime_column_2 - datetime_column_1 | INT | 22 |
All queries in this guide are provided as-is for reference purposes. iDashboards Technical Support Team will not assist with authoring new queries. Please check out Microsoft's Format a date and time field documentation for more information on anything concerning Datetime.
Comments
0 comments
Article is closed for comments.