Creating a date based on concatenated data

ktpp 06-01-2016

Hi I am hoping someone can help.  I have an adobe form which I can not change.  The form has individual boxes for each of the 4 values of a year, 2 for month and 2 for day.  These are all individual boxes that a user enters for example if a person puts in todays date they would enter 2 in one box 0 in another, 1 in another and 6 in another for the year and also 2 digits for the month and day.  This part of the design I am not able to change as the form belongs to another organization.

First I am using adobe Livecycle ES-02.  I have used concat to put together a date like YYYY-MM-DD.  However when I go pull the value of the concatenated variable it returns zero.  How do I format my concatenated variable to read as a date.  Ultimately I am trying to put in a condition that says if today's date -the concatenated variable date is less then 5 years then do this.  I can not do that because the concatenated variable is not reading as a date.

Below is the code which I use formcalc.

On ready layout

var date

date=Num2Date(Date(), "MM/DD/YYYY")

var Sepdate

  Sepdate=(CONCAT(cd,ce,cf,"-",cj,ck,"-",cg,ch)

Here is more code so you can see what I am trying to attempt ultimately.  I have added the message box because I wanted to see the value of Sepdate.  As I said it comes up as 0.

On Exit

date=Date2Num(date, "MM/DD/YYYY") - Date2Num(date, "YYYY-MM-DD")

  

var DateDiff=Num2Date(date,"YYYY-DD-MM")-Num2Date(Sepdate,"YYYY-DD-MM")

 

xfa.host.messageBox(Sepdate)

Any help would be appreciated

Mark Solution

Are these answers useful?
Help other community members by marking useful answers as accepted.

Accepted Solutions (0)

Answers (1)

Answers (1)

Magus069
MVP
08-01-2016

Hi there,

I can see you're error, within LiveCycle you can't declare a variable in an event and use the variable in another event. Even if it's in the same object.

To do this you should have a global variable or a script object that holds your variable and then you access it from any event!!

Hope this will help ya!