Length of service variable

Hi Shane,

I find Javascript date logic (particularly in relation to Lawson's date formats) to be particularly tricky.

Here's how I do it (in Design Studio; you'll have to adjust it for ProcessFlow):

- Put both dates into a date() variable (to do that *correctly* particularly for sites with different locales, see my LawsonGuru article https://www.danalytics.co...archive/2006-09.htm)

- Use a combination of milliseconds, .getTime() and Math.ceil() to get the difference in days.

Here's the relevant code (I've also attached it in a .txt file in case it doesn't render correctly...)

var dateToday = new Date();
var sPostDate = lawForm.getDataValue("CGH-BATCH-DATE")
if (sPostDate == "")
{
sPostDate = portalWnd.edFormatDate("t")
}
var dPostDate = new Date(sPostDate)

//Set 1 day in milliseconds
var one_day = (1000*60*60*24)

// calculate age of posting date & warn if > 90 days ago
var iPostDaysOld = Math.ceil( (dateToday.getTime() - dPostDate.getTime()) / one_day)
if (iPostDaysOld > 90)
{
}