Calculated date field question
Posted on 2013-11-24
I have a field in a form named "ListDate". It is a date/time field with short date as the format.
After an entry has been made in this field I want two other fields to be calculated.
One is named "ListMonth". The other is named "ListYear". So using this entered date as an example...
I want the first calculated date field, "ListMonth", to be 08
I want the other calculated date field, "ListYear" to be 2013.
How can I do this or what is the expression and/or format in the table designer?