End Date Field Automatically Populating to One Year from Start Date Entered

[HubKonnect Studio]

To preface, this will be used on a coupon that currently has a start date and an end date field for the user to choose. The client has asked for end dates to automatically be one year from the start date that is selected with the end date being a required but hidden field for the user. Can. rule be written so the end date field can be automatically populated with a date that is one year from the start date that the user selects? The field names in my flat file data are "OfferStartDate" and "OfferStartDate".

 

Thanks!

[Dan Korn]

var myDate = DateFromString(Field("OfferStartDate"));
myDate.setFullYear(myDate.getFullYear() + 1);
return FormatDate(myDate, "mm/dd/yyyy");

You can format the resulting date however you want in the last line.  (Refer to the Rules Guide.)

[Mike_Marshfield]

@Dan Korn this rule isn’t working that you supplied

var myDate = DateFromString(Field("OfferStartDate"));
myDate.setFullYear(myDate.getFullYear() + 1);
return FormatDate(myDate, "mm/dd/yyyy");

do I need to add or delete something to make it work? I have a todays date rule called “Date Rule” that I replaced the “offerstartdate” 

any advice?

[Alex Marshall]

Did you insert this new Rule from the "Variable" drop window in the FusionPro Variable Text Editor to the text frame used?

[Mike_Marshfield]

So I have a todays date rule and need a rule for one year from today’s date

[Alex Marshall]

Can you collect the job (FusionPro>>Collect) and forward it to fusionprosupport@marcom.com

 

[Mike_Marshfield]

Not sure you will be able to see that email Alex

so my today’s date rule is this

return FormatDate (new Date (), “1m d, yyyy”);

so I need another rule for 1 year from todays date

[Mike_Marshfield]

Alex I got it to work. Just needed to add “Rule” where it says “Field”

[Dan Korn]

1 hour ago, Mike_Marshfield said:

Not sure you will be able to see that email Alex

so my today’s date rule is this

return FormatDate (new Date (), “1m d, yyyy”);

so I need another rule for 1 year from todays date

In that case, you don't need that second rule to format the current date just to have the other rule call it.  You can just have a single rule like so:

var myDate = new Date();
myDate.setFullYear(myDate.getFullYear() + 1);
return FormatDate(myDate, "mm/dd/yyyy");

or:

var myDate = Today();
myDate.setFullYear(myDate.getFullYear() + 1);
return FormatDate(myDate, "mm/dd/yyyy");