1 of 1 people found this helpful
Can you just combine the two:
DATEADD('month', -5,DATE(RIGHT([FiscalPeriodID],2) +"/15/" +LEFT([FiscalPeriodID],4)) )
This works fine. You could also convert the right(fiscal) to an integer, substract 5 and change it back to a steing, but this seems as easy.
Perfect! Thanks Alex!