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

[Shiva Duriseati]

Hi Meryem, I am able to get the values by passing formatted date to the select query. Can you try as suggested below? var dateVar =new Date(); var formattedDate=rbf_formatDate(dateVar , "yyyy-MM-dd HH:mm:ss"); rbf_selectQuery("SELECT name FROM DateTest_1 where myDateTime <='"+formattedDate+"'", 10, function callback(arr){ console.log(arr); }); Regards, Shiva

Continue reading...