Hi,
I do have a question based the "Dynamic Select" tool. I have the following column:
and i like to have only the column until todays quarter "Q22022".
Does anyone know how to make this happen?
Thanks,
Ali
Solved! Go to Solution.
Transpose, identify current year quarter, then filter
IF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="01" THEN "Q1"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSEIF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="02" THEN "Q1"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSEIF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="03" THEN "Q1"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSEIF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="04" THEN "Q2"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSEIF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="05" THEN "Q2"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSEIF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="06" THEN "Q2"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSEIF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="07" THEN "Q3"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSEIF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="08" THEN "Q3"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSEIF
DateTimeFormat(ToDate(DateTimeNow()),'%m')="09" THEN "Q3"+ToString(DateTimeYear(DateTimeNow()), 0)
ELSE
"Q4"+ToString(DateTimeYear(DateTimeNow()), 0)
ENDIF
@IraWatt I created a test workflow, where you can see the point where i am stuck
@DataNath I had to add the "Tile" tool to increment based on the "name" which is the date.