Hi, we have an option variable called lastExportDate and a field called lastModified. When we are trying to find the difference between two values using DaysDiff, we are not getting any result. Can somebody please help out with the Javascript code and the expression to use in additional data?
Hi @sanjana12 ,
Considering your option's Data type is 'Date+time'
In workflow, fetch the option value and store it in variable as below,
vars.lastExportDate=getOption('lastExportDate');
In Query additional data or in enrichment, add the below expression to fetch the Days difference,
DaysDiff(ToDateTime($(vars/@lastExportDate)),@lastModified )
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.