Date based on Variable

[#1]

Hi

I am trying to create an SLA_Date in my load script using the order_date plus the SLA_Days which is a variable called vSLA. It's value is currently = 3. I tried this script:

Date(Order_Date + vSLA) As SLA_Date

but this failed. Any suggestions? Thank you.

Don

[johnw]

Date(Order_Date + $(vSLA)) As SLA_Date

[#3 · Accepted solution]

Thanks John. That worked. Just a question. Why do you include the $ if this is a load script? I'm still learning the scripting language.

[johnw]

Heh, to be honest, because it didn't work without it. I haven't really nailed down the rules for when I just state the variable and when I need to put $() around it. I'm sure they're simple, but so far it's been trivial for me to do it one way, and if it doesn't work, do it the other way. After five years, you'd think I'd have learned something as simple as this, but no. *chuckle*

[#5]

Well your a very kind and patient man for helping all these newbies like me. Take care.