5 Replies Latest reply on Dec 1, 2016 1:17 PM by philmodjunk

    Exporting File Path using Variable


      I've been racking my brain all day and searching endlessly without solution.


      I'm trying to export the contents of a container field into a sub-directory. Therefore I'm creating a variable to use as the file path, but apparently what I'm using won't work past the sub-directory.


      Here's the calculation for variable that does work:

      Left ( $newFilePath ; Length ( $newFilePath ) - $fileName )  &  "Receipts"


      Here's the calculation for the variable that doesn't work:

      Left ( $newFilePath ; Length ( $newFilePath ) - $fileName )  &  "Receipts/" & Year ( Transactions::Date )


      How can I append the "year" as a sub-directory onto my path?