I have setup a stock status export baq.
When I schedule it for export there is a field to enter a file name. I would like to append the current date to that file name and wondering if there is a magic syntax to do that like maybe add a or something like that?
Thanks,
DaveO
You could try the getdate() function.
On second reading, I think I understand what you’re trying to achieve. You want the user to enter the file name and the system will save the file with the enterd name concatenated with a date?
There is probably a better way to achieve this, but a hack is that you can customize the form to put the field outside viewable area and have a custom field for the file name. Use a ValueChanged event to take the entered file name concatenated with the current date and populate that into the system file name field.