Hi ,
Looking to retrieve data from datatable using Timestamp field . I have requirement like retrieve current date data , weekly data (last 7 days) etc. here timestamp values can be duplicated . we want last 7 days entries from datatable. how we can do it?
Thank you
Hi Ciprian-Traian ,
I have done this requirement by using below code and it worked.
var days=7; // Days you want to subtract
var currentdate = new Date();
var lastDate = new Date(currentdate.getTime() - (days * 24 * 60 * 60 * 1000));
var day =lastDate.getDate();
var month=lastDate.getMonth()+1;
var year=lastDate.getFullYear();
logger.warn(lastDate);
//logger.warn(day);
var query =
{
"filters": {
"type": "Between",
"fieldName": "timestamp",
"from": lastDate,
"to": currentdate
}
};
Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
