Typical task pupulating database field with current date can be be done in several ways
First of all we can use GetSystemVariable calculation function:
GetSystemVariable returns value of 'VARIABLENAME'.
Possible values for 'VARIABLENAME' are:
GetSystemVariable('SYSTEM_DATE') function teturns date according to the regional settings of computer.
It very important to use currect date format form the regional settings screen we can see that the format is dd/mm/yyyy
Another way to determine date format of GetSystemVariable('SYSTEM_DATE') is to execute it against non date field
Mapping using MS SQL Server connection with no date format
Data preview screen
Mapping using MS SQL Server connection with currect date format
If we specify wrong date format I won’t be able to load the data
As you can see order date field is missing.
Another way of getting data is by using GetSystemDate function
GetSystemDate(Format):String, Returns Current system date/time in format specified
And last way is to use database functions for example getdate() for sql server
It does not work for MS SQL Server Connections use ODBC connection instead.
You may get error message saying that field must have date format. Just assign any date format.