topic NOW/DAY - 1DAY not giving desire result in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/now-day-1day-not-giving-desire-result/m-p/139073#M37231 <P>Hi,</P><P>I am trying to get the timestamp of yesterday morning 12:00 AM using&nbsp;, which is not yielding&nbsp;the correct result. My requirement is to generate the report for the documents which got processed yesterday.</P><PRE>cm:created:[NOW/DAY - 1DAY TO NOW/DAY]</PRE><P>Please suggest?</P><P>Thank You</P> Mon, 21 Mar 2022 06:28:01 GMT harmesh 2022-03-21T06:28:01Z NOW/DAY - 1DAY not giving desire result https://connect.hyland.com/t5/alfresco-forum/now-day-1day-not-giving-desire-result/m-p/139073#M37231 <P>Hi,</P><P>I am trying to get the timestamp of yesterday morning 12:00 AM using&nbsp;, which is not yielding&nbsp;the correct result. My requirement is to generate the report for the documents which got processed yesterday.</P><PRE>cm:created:[NOW/DAY - 1DAY TO NOW/DAY]</PRE><P>Please suggest?</P><P>Thank You</P> Mon, 21 Mar 2022 06:28:01 GMT https://connect.hyland.com/t5/alfresco-forum/now-day-1day-not-giving-desire-result/m-p/139073#M37231 harmesh 2022-03-21T06:28:01Z