SQL Macro with Variable expect end function

Carla van Zyl

• October 31, 2023 06:33

Hello!

I am trying to calculate the date automatically based on the lead time Days in @Address ETD UDT. 
My debugger give me an end error. I have tried different variations but I cannot get it right. Any Advice? 

 

 

Vote

0

• 

  Geoff Booth

  • October 31, 2023 18:00

  @STORE1 =  "your SQL to select Lead Time in Days"; One thing at a time

  MessageBox(@STORE1); \\to verify your number of days

  Set ($[$U_ETD.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), DateAdd(DD,@STORE1,GETDATE()),120));

  //The main reason is that the date has to be in format YYYY-MM-DD

Please sign in to leave a comment.