Date Attribute math/calculations?

Get help. Get answers. Let others lend you a hand.

Moderator: Mr_Noodle

Date Attribute math/calculations? Fri Jan 18, 2019 5:20 pm • by gcoghill
Is it possible to do any sort of date manipulation/math/calculation for renaming?

For example, if I download a Q4 .csv file after the quarter is over, I'd like to be able to rename the file using the "quarter" date token, but modified to return the previous quarter.

Usually I download the files for a financial quarter after that quarter has already ended, so being able to manipulate that date calculation would be handy.

Trying to avoid having to create 4 separate rules, one for each quarter and analyzing the Date Created.
gcoghill
 
Posts: 290
Joined: Tue Sep 18, 2007 8:09 am
Location: Kent, OH

Re: Date Attribute math/calculations? Mon Jan 21, 2019 11:54 am • by Mr_Noodle
You can use the "Adjust date" function to make calculations like that. It's available in the date attribute after you drag it into your pattern.
Mr_Noodle
Site Admin
 
Posts: 11195
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Re: Date Attribute math/calculations? Mon Jan 21, 2019 1:50 pm • by gcoghill
Man, I do not know how I overlooked that! Exactly what I needed, thanks!
gcoghill
 
Posts: 290
Joined: Tue Sep 18, 2007 8:09 am
Location: Kent, OH


Return to Support