-
Thanks for that Jimmy, I will.
Extra brackets. means brackets to enclose the calculation for today's date, and brackets around the entire calculation for the other date. It is remarkable that it did happen. I think that round somehow must affect the small values for month and day of the month.
Yet the brackets as I ...
-
I created a repeating table for the master table.
And a separate section for each other table within the repeating section.
As I didn't have to intermix the data in the subordinate tables on the form, everything should be okay.
Thanks all for your help.
-
Hi Anuma,
I think your method in the link is a bit complicated. Because you are trying to analyse the months individually, and the days also. It is not necessary.
The best solution is to convert the whole date to a decimal value, deduct one date from the other and find the whole integer part of that number.
As in the formula I was ...
-
Hi,
I am trying to calculate the age of a person, the field name is cust_dob
the formulae I used, I copied and modified from posts on calculating age,
in an expression box is
floor( ( ...
-
Thanks Anuma, I will give it a try. Sorry for the late reply, I have got a few issues I am trying to sort out.
I don't quite understand how it will work though.
On a note, I think I have a very large form, over 190 Access fields, and many more InfoPath controls.
So I have a an Entry form, a Print View form,
and now you say ...
-
I am a newbie, and I am still treading carefully through the amazing structures that can be built with InfoPath.
Thank you all people for earlier reply postings to my queries.
Some of the replies I have not quite understood, and some seem to have typos.
I am sure some of my questions were much the same too.
My problem:
In my ...
-
Shiva, if I have a CHECKBOX I would have thought that it would be a short lengthed field, something shorter than a string of one character.
So can you imagine my amazement that to actually alter a checkbox through another fields rules, that I have to enter a STRING "true" or "false".
Initially I only used true() ...
-
Thank you swathip.
I found I think the solution, And that is tio physical enter a text string "True" or "False" for a CHECKBOX.
Now that is ODD. Why would these controls consume so much space???? And not have Booloean or other swith (on off).
So, in effect a Checkbox is at least 5 characters ...
-
Thanks for the info about margins skarn. But it didn't answer the question.
I have found by adding a section, and applying a condition to the section I can insert a Carriage Return.
The only data in the section is a CR of course.
But, I am not sure at this point, if the fact that the CR is there in the form, a lCR ...
-
Thanks for that Swathip.
It works well.