SQL Macro with Variable expect end function
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? 
Comentarios
1 comentario
@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
Iniciar sesión para dejar un comentario.