Skip to Content
Author's profile photo Former Member

How to get month name that sorts right from string containing partial date

If you have Year and Month (partial date) as a string in a HANA view (as given below) but need the month name in the correct sorting order, you can do the following.


     Created a calculated column and used the following case statement.


Formula in text


     This gives the following output…


and it sorts in the right order too!


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.