From Date and To Date difference should not be more than 90 days

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. 

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


Solution

Use  AddDays to add days to another date.

Hello Seetha Ganesan,


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


DiffDays(Fromdate, ToDate)

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

 


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