5 Replies Latest reply on May 1, 2016 1:51 PM by StephenWonfor

    Export data to file using Current Date and Time as filename


      I have success in exporting selected data to an excel file and email out accordingly.


      In my current script, I have the following:


      Set Variable [$filepath; Value: "filewin:" & Get (DocumentsPath) & "TEMP.xlsx"


      I would like to know how to name "TEMP.xlsx" with "current date and time.xlsx"


      I have tried "%Date%%Time%" & ".xlsx" but FileMaker does not like it


      Can anyone help me please?