[progress Communities] [progress Openedge Abl] Forum Post: Re: 4.0.4 - Select Query With A...

[Shiva Duriseati]

Hi Meryem, In that case,please use the following code: var givenDate=new Date(); var utcDate = givenDate.toUTCString(); //utcDate is a string and this needs to be converted to Date object since rbf_formatDate accepts only Date object. //If you want to compare date along with the exact time you can use rbf_formatDate(d,"yyyy-MM-dd HH:mm:ss") var dateVar=rbf_formatDate(new Date(utcDate), "yyyy-MM-dd"); rbf_selectQuery("SELECT name FROM DateTest_1 where myDateTime <='"+dateVar+"'", 10, function callback(arr){ console.log(arr); }); Regards, Shiva

Continue reading...