dosborne99

Exporting File Path using Variable

Discussion created by dosborne99 on Dec 1, 2016
Latest reply on Dec 1, 2016 by philmodjunk

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?

Outcomes