Issues with Date Formatting for two digit year

I'm loading in a %m/%d/%Y date into TSpot with EoM like:

01/31/19, 02/28/19, 03/31/19, etc.

When loading data into my instance, I am getting values:

01/31/1919, 02/28/1919, 03/31/1919, etc.

I have 'Formatted' the field in the table to be M/YY as per the user manual, which returns 1/19, 2/19, 3/19, etc. as expected; however, when putting this date field into a worksheet (maintains M/YY format) I get dates like:

01/31/1919, 02/28/1919, 03/31/1919, etc. 

I have yet to be able to get the 1919 to change to 2019 (aside from changing the underlying data).  From the User Guide, it states that years below 67 should default to a '20' prefix but this clearly isn't the case.  Has anyone else had issue with this?

Currently running 5.2.cu1 on a PoC env.

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 8 mths agoLast active
  • 4Replies
  • 32Views
  • 3 Following