OQL Date Query

Hi All,    As I am trying to fetch the Monthly data from the excel sheet with the help of OQL  queries and executing  that by excute oql statement i can see the exact data that what is having in excel but i can see the difference for the date and time column. As from the excel i can see the date format as 01/06/2023 but after the query  i can see the date as 1688169600000.    Can any one pls help me how to convert this.   Pls find the below screen shot of the query:-    This is the output for the date and time column:-     
1 answers

Hi there,


You would need to manipulate the data you obtained. There is a Java action in the CommunityCommons module, that can convert the long to date time (LongToDateTime).


Hope it helps!