I'm trying to calculate the difference (in days) between two dates from a CQ VB script:
SetFieldValue "Date_Current", now ()
firstDate = GetFieldValue ("Date_Threat").GetValue()
secondDate = GetFieldValue ("Date_Current").GetValue()
result = DateDiff(firstDate, secondDate)
CQ doesn't use DateDiff (in the script format that I'm using).
Is there a way I can calculate the difference in CQ? I'm a beginner.
Thanks in advance. JDD223