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)