Expand my Community achievements bar.

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
Former Community Member

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
Former Community Member

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

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----