Forum Discussion
KatieH
Advocate IV
Advocate IVFuture Quarters Display
Hi all, I'm sure this is quite straightforward but I'm really struggling to figure it out. I have a report page which is showing the current quarter and next 4 quarters worth of data and I want t...
Hi!
Do you want to be able to reference the date, or is just the text string "YYYY QQ" fine? If text only is okay you could create something like this:Quarter + 0 := VAR VarDate = today() return format(VarDate,"yyyy")&" Q"&format(VarDate,"q") Quarter + 1 := VAR VarDate = edate(TODAY(),3) return FORMAT(VarDate,"yyyy")&" Q"&FORMAT(VarDate,"q") //and so on...To get measures that update dynamically.
Hope this helps!
TomasAndersson
Solution Sage
Solution SageHi!
Do you want to be able to reference the date, or is just the text string "YYYY QQ" fine? If text only is okay you could create something like this:
Quarter + 0 :=
VAR VarDate = today()
return
format(VarDate,"yyyy")&" Q"&format(VarDate,"q")
Quarter + 1 :=
VAR VarDate = edate(TODAY(),3)
return
FORMAT(VarDate,"yyyy")&" Q"&FORMAT(VarDate,"q")
//and so on...
To get measures that update dynamically.
Hope this helps!
KatieHAdvocate IV
Advocate IVThis is perfect TomasAndersson - thank you so much!