Hello All I am running a schedule that has the following dyn...

[Naeem Sufi 3]

Hello All

I am running a schedule that has the following dynamic Excel file name to store the report

ESS_HR_Audit_&RANGE_BEG_DATE|-&RANGE_END_DATE|.xls in the Save Report As

8.2.7 does not like the Vertical Bar |

|(FOC002) A WORD IS NOT RECOGNIZED: |.|

Any idea what to use in 8.2.7 for |

Thanks

[Martin Yergeau]

Are you sure that is the pipe and not the fact that the variable contain only a dot (or missing)

Saying that because you cannot have a files name with more than one dot in it since you already have .xls

Check that value of your two variables

[David Beagan]

What about this:

ESS_HR_Audit_&RANGE_BEG_DATE-&RANGE_END_DATE...xls

[Debra Waybright]

It could also be that you dont have spaces on either side of your pipe symbol.

[Naeem Sufi 3]

Thank You MartinY andDavid Beagan I removed the extra dot and it works