11 Replies Latest reply: Apr 17, 2018 3:24 PM by Marco Wedel RSS

    Whats up with year

    David Whelton

      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.

       

      I've tried

       

      Date#(F1, 'YYYY')     appears as 2017.00000

      Date(F1, 'YYYY')       appears as 1905

      Year(F1)                    appears as 1905