If I understand you correctly, you need a file suffix that should contain a date in a specific format (only year and month) and that date should represent a previous month of the current date.
Okay, it’s a bit tricky in TDP 3.2 but is still doable. Use VBA functions for this. For some reason Format() is not supported so you’ll need to go a longer way. The following expression returns year and month part of a date which is one months earlier in yyyy_dd format:
CStr(Year(DateAdd(“m”, -1, Now))) + “_” + String(2 - Len(CStr(Month(DateAdd(“m”, -1, Now)))), “0”) + CStr(Month(DateAdd(“m”, -1, Now)))
Let’s say we put this as a value of some variable SomeVar. In this case something like
should produce what you need. See an example in the attached script. This script uses connection to Toad Sample Database.