rtolliver

Year Function does not return correct value.

Discussion created by rtolliver on Mar 16, 2016
Latest reply on Mar 16, 2016 by rtolliver

While testing the Year function in combination with Get current date, I expected to have the current year returned to the test field "Year" which is a date calculation with defined the options.

 

Example Todays date: March 16, 2016

Field Calculation Option: Year( Get(CurrentDate))  //Expected 2016


When I created a new record the Year field contained "0006"


Can anyone tell me what may have caused this?  I added a new date field to test Get(CurrentDate) and it work find which means that the correct date is being passes to the Year() function.

Outcomes