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

    Exporting File Path using Variable

    dosborne99

      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?