AnsweredAssumed Answered

Calculated value not producing same results

Question asked by ShawnFitzgerald on Aug 12, 2014
Latest reply on Aug 13, 2014 by philmodjunk

Title

Calculated value not producing same results

Post

     I am using a auto  enter calculated value to produce a unique number for records.  I have done this with a couple records already but now its not working for a new record I am doing and I don't know why.

     The calculated value is as follows

     Month ( DATE ) & "-" & ID

     it only displays the  - ID not the 2 digit month

     the only difference I see is in the options on the ones that worked it says indexed and in the new table options it does not say indexed.

     also I would love it if I could get it to display the 2 digit year as well so my final product  would look like this "0814-1234" 1234 represents the ID 

     What am I missing here 

Outcomes