If I try to create a user variable with the following formula, it resolves to the correct value before I go to save it, but after I save it and re-open it, it fails with "error in arguement". The process of saving it changes the "<" symbol in the Logic statement to "<".
Our Fiscal year is from July to June. I want to create a directory structure with the months sorted in that order, so I'm trying to preface the folder name with a two digit value. That's what this statement is trying to do. If the modified month of a file is less than 7, I add 6 to the month value, otherwise, subtract 6. The result (when combined with the month) would be 01-July, 02-August, 03-September,....11-May, 12-June).
Is this a bug or am I doing something wrong?
Before Saving:
{LOGIC(If|Integer|{FILE(ModifiedTime|c:\testfile.txt|%M)}|<|7|{MATH(Add|Integer|{FILE(ModifiedTime|c:\testfile.txt|%M)}|6|#00)}|{(MATH(SubtractIInteger|{FILE(ModifiedTime|c:\testfile.txt|%M)}|6|#00)}
opened up after saving:
{LOGIC(If|Integer|{FILE(ModifiedTime|c:\testfile.txt|%M)}|<|7|{MATH(Add|Integer|{FILE(ModifiedTime|c:\testfile.txt|%M)}|6|#00)}|{(MATH(SubtractIInteger|{FILE(ModifiedTime|c:\testfile.txt|%M)}|6|#00)}