Date within 12 months

Help
#1

Hello,

I have a data source named people. In the data source I have a date property for when that person is expected to leave.

Is it possible to create a list view of people based on a date range, I.e. between today and 6 months, or today and 12 months?

#2

Hi,
you can use the Advanced Search section of the Datasource.
You will need to add to AND conditions.

For example, if you want all the persons that leave in the next 12 months, you will need to add a Condition with leaveDate before today + 12 months.

For the today + 12 months you will need a function like this:

image
image1078×336 36.4 KB

where 31536000 = 60(sec) * 60(min) * 24(hours) * 365(days)

Thanks
Kostas