Date & Time

Question

Hello, 
 
 I need to pass the yesterday's date and a specific time to a variable of dateTime type. Basically today I want to get all the data which is saved in database yesterday. How to achieve this? 
 
 Thank you.

Mathieu Drouin · Answer

Hi, 
 I provided answers to 2 previous threads of yours which show how to create filters and calculate datetimes. 
 Filter for previous month:

To find if a given date is from previous month

Suggested Answer

Hi 
 
 I need to find out if a particular date which is stored in record type is from the previous month. For example today in September I'm finding that 7th of August 2023 date (Already present in record…

By prachit0003 10 months ago in Discussions > General

10 replies

Latest by prachit0003 10 months ago

Filter for last 45 days:

How to Generate Report Based on the User Filters

Verified Answer

Hello, 
 
 In a interface using process model I'm generating the Report in Excel using Export Data Store Entity To Excel Smart Service on Monthly and daily basis, and in smart service inside filter field…

By prachit0003 10 months ago in Discussions > User Interface

7 replies

Latest by Mathieu Drouin 10 months ago

Would be very similar to the 45 day answer, except you subtract 1 day instead of 45 and pass 00:00 in the hours/minutes/seconds fields of the startDateTime and 23:59:59 in the endDateTime. 
 If an answer helps you, please mark it as verified so that others can find it later.

Date & Time

Top Replies