By using this website, you agree to our Terms of Use (click here)
I am building an Export Scenario using data from Invoices and Memos.
I am mapping the Post Period from the invoice which contains an example value of "082024"
I would like to use the LEFT function to only extract the "08" value for Period.
What is the syntax for the LEFT function on the Invoice Summary / Post Period field?
I have tried the following, but none have worked. I receive errors from Missing Operand to Invalid Hdr when running my Export Scenario:
=LEFT(FinPeriodID, 2)
=LEFT([FinPeriodID], 2)
I am only able to export the whole value of this field in my mapping.
Try =RIGHT([FinPeriodID], 2)
It's stored in the database as yyyymm
Thanks Tim, but this ended up being an issue with the Field Name reference itself, not the LEFT() function.
Once that was corrected, the LEFT() function works fine.