I'm completing a government return which will need to be sent daily and they require the file to be named as below:
"
File naming:
CAZ-yyyy-mm-dd-XXXX-#.csv
where:
yyyy-mm-dd represents the date the file was generated
XXXX is the agreed identifier for each Licensing Authority (to be confirmed)
# is the total number of records included in the file.
"
The date is easy enough to solve, but I'm hitting a brick wall trying to insert the feature count into the file path. So far I've got:
CAZ-@DateTimeFormat(@DateTimeNow(),%Y-%m-%d)-XXXX-#
Could anyone help with the #?