Wanting to take a string month name and turn it into a valid month date format..
for example: fcn("January") = 1
Also, how do I change the value of the month, e.g. 1, back to January?
for example, fcn(1) = "January"
I know I could do a select case to do this the long way, but thought maybe there was already a built in access function to do this..
Thanks for any assistance..
for example: fcn("January") = 1
Also, how do I change the value of the month, e.g. 1, back to January?
for example, fcn(1) = "January"
I know I could do a select case to do this the long way, but thought maybe there was already a built in access function to do this..
Thanks for any assistance..