Date Field Trouble

[Former Community Member]

Hi All,

I have been trying to automate a pdf form available to Landlords in my city using Livecycle. The trouble is that I have two date fields which indicate a date range for the lease period and I require that it updates the year every year however, the date needs to stay the same from July 1st until June 30th. I've been searching this forum as well as Google with no luck and I have also experimented with bits of code (I'm a complete beginner). Any input is appreciated.

Thanks

[Former Community Member · Accepted solution]

Here is the FormCalc example....how to do it...I used this code in "docReady" event of StartDate.

if (StartDate.isNull) then
var thisYear
var nextYear
thisYear = Num2Date(Date(), "YYYY")
nextYear = Num2Date(Date(), "YYYY")+1
var sDate
var eDate
sDate = Date2Num(concat("07/01/", thisYear), "MM/DD/YYYY")
eDate = Date2Num(concat("06/30/", nextYear), "MM/DD/YYYY")
//xfa.host.messageBox(sDate);
//xfa.host.messageBox(eDate);
StartDate.rawValue = Num2Date(sDate, "YYYY-MM-DD")
EndDate.rawValue = Num2Date(eDate, "YYYY-MM-DD")
endif

[Former Community Member]

You are my saviour, thank you very much.

Mike