J
JLS04
In one of my tables, I have a date field formatted as MM/DD/YYYY. I would
like to grab the month only to use in another field, but because the date
shows as 8/30/2005 or 10/1/2005, I can't use the "left" command because
sometimes the month is one character and sometimes it's two. Is there a way
to pick the month out of the date?
like to grab the month only to use in another field, but because the date
shows as 8/30/2005 or 10/1/2005, I can't use the "left" command because
sometimes the month is one character and sometimes it's two. Is there a way
to pick the month out of the date?