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

    Export data to file using Current Date and Time as filename

    tikidewey

      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?