Hi all,
I need to get todays date, and then generate a new date 7 days from todays date.
I can do this in excel and it works
Dim newdate
newdate = DateAdd("d", 7, Date)' adds however many days
newdate = Format(newdate, "ddmmyy") 'formats my date
MsgBox newdate
In this case I will only be working with Extra, I will not be running excel.
When I use the above code in Extra I get a Variable Dateadd undefined
Is there a method in which this issue can be resolved?
Many thanks,
James
I need to get todays date, and then generate a new date 7 days from todays date.
I can do this in excel and it works
Dim newdate
newdate = DateAdd("d", 7, Date)' adds however many days
newdate = Format(newdate, "ddmmyy") 'formats my date
MsgBox newdate
In this case I will only be working with Extra, I will not be running excel.
When I use the above code in Extra I get a Variable Dateadd undefined
Is there a method in which this issue can be resolved?
Many thanks,
James