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:-
asked
Pavithra KasiReddy
1 answers
1
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).