Sign in to Community
Sign in to view all badges
In ACC WebApp I am trying to get the number of days between System date and Offer date with the below syntax but I dont get anything, even tried converting just to "%2M/%2D/%4Y" that also does not work when used with DaysDiff function.
ctx.vars.OfferDate= formatDate(ctx.recipient.Offer_Date,"%2M/%2D/%4Y %02H:%02N:%02S");
ctx.vars.SysDate = formatDate(getCurrentDate(),"%2M/%2D/%4Y %02H:%02N:%02S")
ctx.vars.datediff = DaysDiff(ctx.vars.OfferDate, ctx.vars.SysDate )
ctx.vars.Time_Diff = ctx.vars.SysDt - ctx.vars.OfferDt;ctx.vars.Date_Diff = ctx.vars.Time_Diff/(1000 * 3600 * 24);
The JS is:
new Date() - new Date(ctx.vars.OfferDate)
Be aware that you're comparing 2 clocks here- the one on the db server and the one on the app server.
A more consistent approach would be to do the math on the db: DaysAgo(@Offer_Date) or whichever resolution is desired.
You should use GetDate() function instead of getcurrentdate()
Can someone move this query to Adobe Campaign Classic please.