incrementing Dates in Repeating tables by 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M Wheeler - 27 Sep 2005 09:01 GMT

Hi
I have a Calendar form I am setting up that has Columns, Monday to Friday.
The header of the repeating tables are the dates in order from a date chosen
in the form eg.
A start date is chosen from the date picker. (31-12-05)
Repeating Table in column Monday is 31-12-05
Tuesday is 01-01-06
and so on til Friday.
I have an expression box in Monday to pick the date from the date picker box
but I am guessing that the expression box in Tuesday needs to pick up the
date in the expression box of monday and add 1 day, but am unsure how to
proceed, can any one help or point me in the right direction?

Many thanks
Mark Wheeler

Reply to this Message

Jay W - 27 Sep 2005 12:25 GMT

To the best of my knowledge, you cannot reference the value of an expression
box. I would have calculate Tuesday by adding 1 to the value from the date
picker, Wednesday by adding 2 to the value from the date picker, etc.

HTH,

Jay

> Hi
> I have a Calendar form I am setting up that has Columns, Monday to Friday.
[quoted text clipped - 11 lines]
> Many thanks
> Mark Wheeler

Reply to this Message

M Wheeler - 28 Sep 2005 01:09 GMT

Thanks for that Jay

After posting the message I thought that this is what I would probably be
doing, being new to infopath and this type of scripting, I'm a cf developer,
can I get any help with the script required to make this work?

Rgards
Mark W

> To the best of my knowledge, you cannot reference the value of an expression
> box. I would have calculate Tuesday by adding 1 to the value from the date
[quoted text clipped - 19 lines]
> > Many thanks
> > Mark Wheeler

Reply to this Message