Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, very new to this.....I am looking to add a group for month/years by financial year (Starts May - Ends April)
(i.e May-2018, June-2018, July 2018, August-2018, September-2018, October-2018, November-2018, December-2018, January-2019, February-2019, March-2019 & April-2019 = 2018-2019)
Current Script....
"Month Closed",
num("Month Closed") AS [Month Closed Num],
monthname("Month Closed") AS [Month Closed MonthYear],
month("Month Closed") AS [Month Closed Month],
REPLACE(Yearname("Month Closed"),'-20','-') AS [Month Closed Year],
Really appreciate any help!
Hi Stephen
Try something like this:
If(Month("Month Closed")< 5,Year("Month Closed")-1&'-'&Year("Month Closed"),Year("Month Closed") & '-' & (Year("Month Closed")+1)) AS FinYear
Good luck.
Mauritz
Hi Stephen
Try something like this:
If(Month("Month Closed")< 5,Year("Month Closed")-1&'-'&Year("Month Closed"),Year("Month Closed") & '-' & (Year("Month Closed")+1)) AS FinYear
Good luck.
Mauritz
Thanks for taking the time to look at that Mauritz, that worked perfectly. Much appreciated.