AnsweredAssumed Answered

Problem with Get(CurrentDate)

Question asked by mjbenun on Mar 29, 2016
Latest reply on Mar 29, 2016 by mjbenun

I have a script that saves an Excel File to my Desktop.

 

The following line in my script is used to set the naming convention:

StyleMaster::Factory &" "&  " ShipSchedule" & Get(CurrentDate)

 

I want this to output FactoryName ShipsSchedule Todays Date, but I am getting an error message regarding the date.

When I remove the Get(CurrentDate) parameter the script works fine and I get “Factory Name ShipSchedule” .  I can’t figure out why the Get command is messing things up- but I have a feeling it has to do with Excel not being able to accept the way the Date is formatted..

 

Please help.  Thanks!

 

Outcomes