AnsweredAssumed Answered

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

Question asked by jiang_aq on Mar 23, 2017
Latest reply on Mar 23, 2017 by Jason Wood

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?

Outcomes