Hi,
I want to frame a query using API2 to retrieve messages for last 90 days. I could not find any built-in available to mannipulate dates and retrieve date past 90 days to pass to query.
Can any one help on it ?
Regards,
Ronak
Hi ronaksomani
the format required for filtering by date in LiQL is documented, for example, in this page (this is for the "Message" resource).
You can then use the Freemarker date built-ins and our datesupport context object to manipulate appropriately your dates for using in LiQL queries.
Hope this helps,
Hi PaoloT ,
I have referred below links for date manipulation.
Tried below approaches :
<#assign date_weekago_number = datesupport.now.addDay(-90).millisecondsAsString?number />
which returns milliseconds as String : 1422380763694
<#assign date_weekago_number = datesupport.now.addDay(-90).getDateAsString() />
which returns date as String in format : 01-27-2015
To frame a LiQL query, I want to convert above strings (date and ms), in requried format.
But freemarker, expects string input in pre-requisite format to convert it into date object.
http://freemarker.org/docs/ref_builtins_string.html
Can you please suggest approach to convert above Strings in required date format.
"post_time" : "2013-09-09T13:42:08.762-07:00",
