This content has been marked as final. Show 11 replies
I am importing an excel sheet with 2017 text.
I am trying to convert it to a YEAR in QV and it appears as follows.
Date#(F1, 'YYYY') appears as 2017.00000
Date(F1, 'YYYY') appears as 1905
Year(F1) appears as 1905