Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.
SOLVED

Date Field Trouble

Avatar

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

1 Accepted Solution

Avatar

Correct answer by
Level 6

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 6

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

Avatar

Former Community Member

You are my saviour, thank you very much.

Mike