Find number of days between system date and Offer date

[akramullak35861]

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 )

Also tried javascript  syntax, this also does not work

ctx.vars.SysDt=ctx.vars.SysDate.getTime();

ctx.vars.OfferDt =ctx.vars.OfferDate.getTime(); 

ctx.vars.Time_Diff = ctx.vars.SysDt - ctx.vars.OfferDt;
ctx.vars.Date_Diff = ctx.vars.Time_Diff/(1000 * 3600 * 24);

[akramullak35861]

Can someone move this query to Adobe Campaign Classic please.

[akramullak35861]

@Jonathon_wodnicki

@Jean-Serge_Biro 

[prasannakumarmarru]

Hi,

You should use GetDate() function  instead of getcurrentdate()

Thanks!

[Jonathon_wodnicki · Accepted solution]

Hi,

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.

Thanks,

-Jon