Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help on Date Conversion
- Thread starter legrev
- Start date
1. Universe-level
Use either a database-function (MONTHNAME) or a CASE statement on an object to work in the conversion
2. Report-level
Use an extensive If .... then .... else
formula on a new object, like:
= If(<field>=1) Then "January" Else
If(<field>=2) Then "February" Else
..................
3. Report-level 2
Create a grouping variable with 12 groups. Call the groups the names of the months and assign the numbers 1-12 to the groups.
Universe solution is really the fancy one!
T. Blom
Information analyst
tbl@shimano-eu.com
Use either a database-function (MONTHNAME) or a CASE statement on an object to work in the conversion
2. Report-level
Use an extensive If .... then .... else
formula on a new object, like:
= If(<field>=1) Then "January" Else
If(<field>=2) Then "February" Else
..................
3. Report-level 2
Create a grouping variable with 12 groups. Call the groups the names of the months and assign the numbers 1-12 to the groups.
Universe solution is really the fancy one!
T. Blom
Information analyst
tbl@shimano-eu.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question