Business Intelligence
help enterprise users make better business decisions
BO Webi Date Format
Posted by on November 2, 2012
| Format String | Formula | Output |
| =CurrentDate() | 02/11/12 | |
| d | =FormatDate(CurrentDate();”d”) | 2 |
| dd | =FormatDate(CurrentDate();”dd”) | 02 |
| Ddd | =FormatDate(CurrentDate();”Ddd”) | Fri |
| DDD | =FormatDate(CurrentDate();”DDD”) | FRI |
| Dddd | =FormatDate(CurrentDate();”Dddd”) | Friday |
| Ddd d | =FormatDate(CurrentDate();”Ddd d”) | Fri 2 |
| Ddd dd | =FormatDate(CurrentDate();”Ddd d”) | Fri 02 |
| Dddd dd | =FormatDate(CurrentDate();”Dddd dd”) | Friday 02 |
| Dddd d | =FormatDate(CurrentDate();”Dddd dd”) | Friday 2 |
| M | =FormatDate(CurrentDate();”M”) | 11 |
| MM | =FormatDate(CurrentDate();”MM”) | 11 |
| Mmm | =FormatDate(CurrentDate();”Mmm”) | Nov |
| MMM | =FormatDate(CurrentDate();”MMM”) | NOV |
| mmm | =FormatDate(CurrentDate();”mmm”) | Nov |
| Mmmm | =FormatDate(CurrentDate();”Mmmm”) | November |
| mmmm | =FormatDate(CurrentDate();”Mmmm”) | November |
| yy | =FormatDate(CurrentDate();”yy”) | 12 |
| yyyy | =FormatDate(CurrentDate();”yyyy”) | 2012 |
| Dddd dd Mmmm yyyy | =FormatDate(CurrentDate();”Dddd dd Mmmm yyyy”) | Friday 02 November 2012 |
| mmm dd, yyyy | =FormatDate(CurrentDate();”mmm dd, yyyy”) | Nov 02, 2012 |
| h:mm:ss | =FormatDate(CurrentDate();”h:mm:ss”) | 1:58:38 |
| hh:mm:ss | =FormatDate(CurrentDate();”hh:mm:ss”) | 01:58:38 |
| hh:mm | =FormatDate(CurrentDate();”hh:mm:ss”) | 01:58 |
| yyyy-MM-dd | =FormatDate(CurrentDate();”yyyy-MM-dd”) | 2012-11-02 |
| dd/MM/yyyy | =FormatDate(CurrentDate();”dd/MM/yyyy”) | 02/11/2012 |
| =ToDate(“02/11/2012”; “dd/MM/yyyy”) | 02/11/12 | |
| Substr(UserResponse(“Select Begin Date (Only for Custom Date Range) “);1;Pos(UserResponse(“Select Begin Date (Only for Custom Date Range) “);” “)-1) | 02/11/2012 | |
| dd/MM/yyyy | FormatDate(ToDate(Substr(UserResponse(“Select Begin Date (Only for Custom Date Range) “);1;Pos(UserResponse(“Select Begin Date (Only for Custom Date Range) “);” “)-1); “dd/MM/yyyy”); “mmm dd, yyyy”) | Nov 02, 2012 |
Business Intelligence 