Skip to Content (Press Enter)
UserImage.jpg
Seetha Ganesan
120Views
5Comments
Solved
From Date and To Date difference should not be more than 90 days 
Question

I have to filter the data by using date rage. Here From Date and To Date, the difference should not be more than 90 days. 

0
0
01 Jan 2020
Copy Link
2021-09-08 08-53-27
Archana Gholap
Solution

Seetha Ganesan wrote:

I have to filter the data by using date rage. Here From Date and To Date, the difference should not be more than 90 days. 

Hi Seetha,

Use DiffDays built-in function provided by OutSystems as shown below.

Thanks and Regards,

Archana Gholap


1
0
01 Jan 2020
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Use  AddDays to add days to another date.

0
0
01 Jan 2020
Copy Link
2018-09-07 10-04-42
Suhas Jamdade

Hello Seetha Ganesan,


Use  DiffDays(#1982-05-19#, #1982-05-21#) = 2


DiffDays(Fromdate, ToDate)

0
0
01 Jan 2020
Copy Link
2021-01-12 14-29-49
Prajakta Roshankhede

Hello Seetha,

If any of the solution worked for you, please mark it as solution so that it will help others too. 

And DiffDays() funtion will definitely solve your problem.

Regards

Prajakta

 


0
0
02 Jan 2020
Copy Link
2024-05-03 14-03-28
Sudip Dey

DiffDays()  will definitely work. If you do not use that you can do the Conversion from date => Day format and also to Date to Day format. Then check the Difference. It can be done.

I hope this will help you,

Sudip

0
0
02 Jan 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.