Answer»
- Use get-time to get the PC system time in seconds since 01/01/1970
- Subtract 86400 (no seconds in a DAY) from it.
- Use time_str to convert the result into a date format.
- If format of returned date is not CORRECT use STRING manipulations to get the format you require.
- INSERT the date into your application.
Alternatively you could try the following:
- In an Excel datasheet create a column with an appropriate name, and in the first cell of the column use the excel formula 'today() - 1'.
- Format the cell to give you the required date format.
- Use the ddt- functions to read the date from the excel datasheet.
- insert the received date into your application.
Alternatively you could try the following:
|