change date to month

[Helen]

Hi,
I have the following problem:

I've created a timesheet in Infopath.

Here's what i want to happen:

Each timesheet entry line has a date. I want to update another field,
called Month, with the current month.

So if the date field says 12th march 2008, the month field
automatically says March.

I know all about rules and how to achieve this. I just can't come up
with the right formula or xpath!!!

can anyone help?!

thanks!
Helen

 

[S.Y.M. Wong-A-Ton]

There is no function to do retrieve the name of the month, so you'll have to
perform a lookup in a predefined XML file. Try this post:
http://groups.google.com/group/micr...lly+populating+month+fields+#7e646b167cf6e024

You can retrieve the number of the month by using the substring() function
on the first date field, e.g. substring(myDateField, 6, 2) will give you the
number for the month for myDateField.