Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Révélation
- Grabbed month letter by taking left character of string
- Created Year field by noting if length is 3, then take rightmost 2 characters, otherwise Null
- If Year is Null, take value of record above
- Set Month Number by numbering field, grouped by year
- Converted month number to month using formula I found in a post from MarqueeCrew - it creates a dummy date (year and day don't matter), then extracting Month using %b
- Eliminated extraneous MonthNum columns
- Grabbed month letter by taking left character of string
- Created Year field by noting if length is 3, then take rightmost 2 characters, otherwise Null
- If Year is Null, take value of record above
- Set Month Number by numbering field, grouped by year
- Converted month number to month using formula I found in a post from MarqueeCrew - it creates a dummy date (year and day don't matter), then extracting Month using %b
- Eliminated extraneous MonthNum columns
Lessons learned: Learned left and right functions, how to insert a Null, a clever date formula courtesy of MarqueeCrew
