bot4.js

function getDateFilter(dateRange) {
    if(!dateRange) return "";
    var chrono = require('chrono-node');
    var dateFormat = require('dateformat');
    
    var dateString = chrono.parseDate(dateRange.entity).toDateString();
    var date = dateFormat(new Date(dateString), "isoUtcDateTime");

    if(dateRange.entity.toLowerCase().indexOf("last") >= 0) {
        return " and CreateDate gt datetime'" + date + "'";
    }
    if(dateRange.entity.toLowerCase().indexOf("before") >= 0) {
        return " and CreateDate lt datetime'" + date + "'";
    }
    if(dateRange.entity.toLowerCase().indexOf("after") >= 0) {
        return " and CreateDate gt datetime'" + date + "'";
    }     
    ...               
}