How can I make my scripts use today for input data, instead of a fixed date?
Very often, when a date is recorded, what you really need in your script is not a fixed date (the actual date that was recorded) but a relative date e.g. today or today + 1 week. For example, when creating a Purchase Order you may want the delivery date to be in the future (e.g. today + 2 days), it is very unlikely that you would always want it to be the exact date you recorded. This is very easy to do and a useful general technique to remember when working with QuickScript. Remember, you are using Excel and all of Excel’s functions and formulas are available to you. All you have to do is replace the date recorded in the sheet with a formula – for example, to use today just use the formula: =TEXT(TODAY(), mm.dd.yyyy) Note the conversion to text, this is to ensure that QuickScript uses exactly the value you see in the cell. Note also the specification of date format, this is critical. The format must be exactly the same as the format you have specified in your SAP user profile (you can
