filter the email was sent within the service date?

(0) Share

Report

Posted on by KaeL

220

i tried to use this to filter the email that was sent within the date from validfrom to validto and this is not working.

var filter = "?$filter=field_InitialEmailSentOn'" + sentOn + "' and field_ValidFrom ge datetime'" + validfrom + "' and field_ValidTo le datetime'" + validto + "'";

And the sentOn that was an array and the data like this

3173.convert.PNG

how to convert the this date time to string? because the validfrom and validto is already converted to string using this

var date = new Date(parseInt(validfrom.replace("/Date(", "").replace(")/", ""), 10));
date = date.toISOString();
return date;

var date = new Date(parseInt(validto.replace("/Date(", "").replace(")/", ""), 10));
date = date.toISOString();
return date;

how to convert the value of sentOn to date and time string? that was from an array?

thanks for the help

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

RaviKashyap 55,410 on at

Like (0)

Report

RE: filter the email was sent within the service date?

Hi Kael,

The date object is an array i.e. it can contains more than 1 value. To get the value of the 1st occurence, you can use something like this-

var date = new Date(parseInt(sentto[0].replace("/Date(", "").replace(")/", ""), 10));

date = date.toISOString();

return date;