Export monthly files

abhinav_datta2004

I want to export files 9 months back from today's date, but always the 1st of that month. I have this working but when the month changes, it doesn't automatically include November for example when doing testing. Is there a way to automate this so I don't have to manually change the time period?

Turribeach

Hi, you will need to give more detail of what you are doing as it is unclear to me. How are you exporting the files? Where are you exporting them to? What does it mean that "it doesn't automatically include November"? (we are in October at the moment). What do you mean by "manually change the time period"?

abhinav_datta2004

I'm exporting the files based on the "lmd" date column. So the initial dataset would then be exported as monthly buckets. For example. file_name_2024-07 if the lmd is sometime in July 2024.

This is what I'm eluding to, when I'm about to build, this comes up. I added test data for November to see if this screenshot would automatically include data for that month, but it doesn't, hence why I have to change the date ranges, does this make sense?