Adding 30 days to a date in a dynamic LC form

[BJasman]

Hello-
I'm working on a dymnamica form that is merged with XML data. In the XML, I get a FirstQuoteDate and bind it to the corresponding field in the form. I then have to calculate the ValidDate by adding 30 days to the FirstQuoteDate and display that date int he Valid Date field.
I've tried several scripts with no luck. Below is the latest script I tried. I also tried the script in several different events. I believe it is the calculate event for the ValidDate field right now. Does anyone know what I am doing wrong?

var QuoteDt = Date2Num(PROPOSAL.Page2Summary.FirstQuoteDate.rawValue, "MM/DD/YY")
var FutureDt = QuoteDt+30
var ValidDt = Num2Date(FutureDt, "MM/DD/YY")

PROPOSAL.Page2Summary.ValidDate.rawValue = ValidDt

[Srini_Dhulipall]

Here is a sample form..

https://acrobat.com/#d=TraLCmZ-W5yvgAvZaMNP9Q

You can verify the patterns for the date fields in properties..

Thanks

Srini

[BJasman]

What event should I be putting this script in? Am I thinking I can't put it in the Change event because the date isn't being entered through the form so the field never actually changes? Do I have to use a different event? The FirstQuoteDate and ValidDates are actually floating text fields in my form. I did find that example out there from a different discussion and have tried this script in the initialize event of the First QuoteDate field and it didn't work for me.

ValidDate.rawValue = Num2Date(Date2Num(xfa.event.newText, "M/D/YYYY")+30,"MM/DD/YYYY");

[Srini_Dhulipall]

If you are trying in the initialize event, then change the code little bit..

ValidDate.rawValue = Num2Date(Date2Num(this.rawValue, "M/D/YYYY")+30,"MM/DD/YYYY");

Try this and let me know.. If you still have issues, you can send it to LiveCycle9@gmail.com, so I can have a look at it..

Thanks

Srini

[Srini_Dhulipall · Accepted solution]

Here is the updated form.

https://acrobat.com/#d=rbDELbBJM-v3O2J1pNddoA

Since I do not have the XML file that is used to populate the PDF, I do not know how the date format could be..

So in the form I tried using the format "YYYYMMDD" ("20101020").. That means my input value for the date in the XML will come in that format.

Then your code also you need to change the format for the rawValue accordingly.

ValidDate.rawValue = Num2Date(Date2Num($.rawValue, "YYYYMMDD")+30,"MM/DD/YYYY");

The other thing you did was set the language to JavaScript.. But the above function will work with FormCalc.

For your testing, I made both the fields as visible instead of hidden.. After you verify, you can set them hidden.

Let me know if you have nay issues..

Thanks

Srini

[BJasman]

Sounds great. Thank you so much for your help. I'll take a look at it right away.

Becca

[BJasman]

Hello-

I have another question if you don't mind. In the same form, in the Auto section, I have two subforms (actually a table and a subform) that have to be bound to the same repeating tag tag.

I'm having a problem with the second item (whether is it the table or the subform) showing any information.

It seems like only the first item that is bound to the tag gets populated with data. Is it possible to bind two items to the same XML tag? Is there something I need to be doing different? Let me know if you'd like to see the form and the XML.

Thanks,

Becca

[Srini_Dhulipall]

Please send the form and XML so I can check it..

Thanks

Srini

[BJasman]

Here you go. Thank you.

[BJasman]

Hi Srini-

Here is an updated copy of my form and the XML as I have been doing some work on it today. The problem is on Page6Auto with the VehiclesList and the VehicleSchedule.

Thanks again,

Becca

[BJasman]

Hi Srini-

Just wanted to let you know I figured out my form and got it working. I used a subform set for my problem table and subform.

Thanks,

Becca