3 Replies Latest reply on Mar 23, 2017 7:39 PM by Jason Wood

    Why calculate field returns "0/0/0000"?

    jiang_aq

      I have two fields:

      SentDate : Data

      SentMonth: Calculation   ---→ Year ( SentDate )& Right (  "0" & Month(SentDate) ; 2 )

       

      When I input in SentDate, for example, 3/15/2017, after I click blank in window, it shows 15/3/2017, and Field SentMonth return: 0/0/0000.

       

      1) why save date format in DD/MM/YY, when I input in is MM/DD/YY? Where can I change it?

      2) why return 0/0/0000? Is it due to the wrong date format?

       

      Thanks in advance?