G
Guest
What I'm trying to do is to pull off the month, regardless of whether it is
7/10/05 or 07/10/05. The first "/" piece (i.e. the piece before the "/")
could have either one or two digits, so the mid([field],1,2) function will
not work. If there were a way to reformat the field so that it always read
10-JUL-05 or 01-JUL-05 this wouldn't be a problem, but when I try to reformat
it, the formula seems to pull from the original format, yielding either "7/"
or "07"...
Help
7/10/05 or 07/10/05. The first "/" piece (i.e. the piece before the "/")
could have either one or two digits, so the mid([field],1,2) function will
not work. If there were a way to reformat the field so that it always read
10-JUL-05 or 01-JUL-05 this wouldn't be a problem, but when I try to reformat
it, the formula seems to pull from the original format, yielding either "7/"
or "07"...
Help