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?