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?