Article Details
Id: | 10818 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 1.06.06 |
Opened: | 26/11/2012 |
Closed: | 07/01/2013 |
Released: | 29/01/2013 |
Job: | J010801 |
Expressions using 'Date' function not working correclty
Expressions, e.g. for Report Templates, do not work correctly when using the 'Date' function, e.g.
Date(2012 + 4, 8 + 3, 1 + 2)
Does not return the expected value of 3/11/2016. It returns the current date.
This was due to the fact that 'Date' can be used as a function with or without parameters and the version without parameters simply (e.g., Date()) simply returns the current date.
This has been resolved so that now, if parameters are specified, they are used to create a date.
NOTE: The 'DateSerial' function can be used as a workaround for earlier versions, e.g.
DateSerial(2012 + 4, 8 + 3, 1 + 2)