change date to month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Helen - 16 Feb 2008 13:59 GMT

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

Reply to this Message

S.Y.M. Wong-A-Ton - 16 Feb 2008 22:57 GMT

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/microsoft.public.infopath/browse_thread/thread/6e
e821c7ce359b85/7e646b167cf6e024?hl=en&lnk=gst&q=Automatically+populating+month+f
ields+#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.
---
S.Y.M. Wong-A-Ton

> Hi,
> I have the following problem:
[quoted text clipped - 16 lines]
> thanks!
> Helen

Reply to this Message