Converting Numeric MONTH to text (i.e. 1=Jan, 2=Feb)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there.
(1) First, I'm trying to use the MONTH expression and convert the month of a
datefield to the actual name of the month. Example of what I'm trying to
accomplish: month( 01/12/2005) = "JAN" (instead of returning the value of 1)

(2) Secondly, I have a datefield labeled Date of Birth. What I ultimately
would like to accomplish is to have a second data element (text field) that
would read the Date of Birth field, convert the month and automatically
populate with the "month" of that date of birth value. EX: If DateofBirth
field is populated with 01/12/2005, then I would like the newly created data
field to "automatically" populate itself with the value of "JAN".
IS THIS POSSIBLE? DOES ANYONE KNOW?

I'm stumped. Any help would be appreciated!
 
Hi there.
(1) First, I'm trying to use the MONTH expression and convert the month of a
datefield to the actual name of the month. Example of what I'm trying to
accomplish: month( 01/12/2005) = "JAN" (instead of returning the value of 1)

(2) Secondly, I have a datefield labeled Date of Birth. What I ultimately
would like to accomplish is to have a second data element (text field) that
would read the Date of Birth field, convert the month and automatically
populate with the "month" of that date of birth value. EX: If DateofBirth
field is populated with 01/12/2005, then I would like the newly created data
field to "automatically" populate itself with the value of "JAN".
IS THIS POSSIBLE? DOES ANYONE KNOW?

I'm stumped. Any help would be appreciated!
Click to expand...

All you need is to store the actual date field [DateofBirth].

As Format property for the [DateofBirth] field, write:
mmm

Both #1 and #2 are the same. Store only the date field.
 
Hi there.
(1) First, I'm trying to use the MONTH expression and convert the month of a
datefield to the actual name of the month. Example of what I'm trying to
accomplish: month( 01/12/2005) = "JAN" (instead of returning the value of
Click to expand...
1)

Make the record source of the text field that displays the month name:

=Format([Date of Birth], "mmmm")

The above is the answer to BOTH questions.
(2) Secondly, I have a datefield labeled Date of Birth. What I ultimately
would like to accomplish is to have a second data element (text field) that
would read the Date of Birth field, convert the month and automatically
populate with the "month" of that date of birth value. EX: If DateofBirth
field is populated with 01/12/2005, then I would like the newly created data
field to "automatically" populate itself with the value of "JAN".
IS THIS POSSIBLE? DOES ANYONE KNOW?
Click to expand...

Tom Lake
 
Back
Top