I am creating the Access expression builder to create a field in a table, drawing from other fields in the same table.
I have an existing date field in the table that has the format dd/mm/yy.
I want to get the month from this existing date field.
The expression I am using is:
& Month([Date])
This works, but for single digit months (eg January), only return 1
I need the returned value to be 01.
Can someone please assist.
I have an existing date field in the table that has the format dd/mm/yy.
I want to get the month from this existing date field.
The expression I am using is:
& Month([Date])
This works, but for single digit months (eg January), only return 1
I need the returned value to be 01.
Can someone please assist.