LEFT, RIGHT FUNCTION
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, I have 2 columns with qtrs formatted as Q2/15 and so on.
My calculation for deliquent quarters will look at both these quarter fields. Since i cant subract in this format, I used the LEFT function to extract the year values from both the fields which works fine.
However, when i use the right function to get say the value 2 in Q2/2015, i get all 0s. Is there a regular expression i can use or try something else. I just need number 2 from Q2/2015. I have tried trim function as well.
Thanks!
Solved! Go to Solution.
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a date in format FY21 and i've taken the Right 2 to give me 21 but i want to append a hard coded 20 before this to give me "2021" how would i do this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ufarooq: "20" + Right([Year],2). Alternatively: Replace([Year],'FY','20')

- « Previous
-
- 1
- 2
- Next »