In Orcanos System, we have the list of Operands for Dates which can be used to generate the Reports. Reports which contains only the required and specific data.
For Date, we have the list of operands:
- is : Used to View data on the specific date
Format : DATE Field is <Select date from Calendar>
- isn’t : Used to View data on all dates except a specific date
Format : DATE Field isn’t <Select date from Calendar>
- is before : Used to View all data before the specific date
Format : DATE Field is before <Select date from Calendar>
- is after : Used to View all data after the specific date
Format : DATE Field is before <Select date from Calendar>
- between: Used to View the data between specific dates
Format : DATE Field between <Select date1> <Select date2>
- not between : Used to View all data except between specific dates
Format : DATE Field not between <Select date1> <Select date2>
- Today : Used to View data of Today
Format : DATE Field Today
- Today Onwards : Used to View data having future dates include today data. User can set the TODAY_PLUS parameter value to get data starting from next X days
Format : DATE Field Today Onwards $(TODAY_PLUS) 0
- Till Today : Used to View data having Past dates including today data. User can set the TODAY_MINUS parameter value to get data till previous X days
Format : DATE Field Till Today $(TODAY_MINUS) 0
- Last X Days : Used to View Past X days data including today data. User can set the DAYS parameter value to get data of previous X days
Format : DATE Field Last X Days $(DAYS) 0
- Next X Days : Used to View Next X days data including today data. User can set the DAYS parameter value to get data of next X days
Format : DATE Field Next X Days $(DAYS) 0
- Tomorrow : Used to View data of Tomorrow
Format : DATE Field Tomorrow
- Tomorrow Onwards : Used to View data having future dates. User can set the TOMORROWPLUS parameter value to get data starting from next X days
Format : DATE Field Tomorrow Onwards $(TOMORROWPLUS) 0
- Yesterday : Used to View data of Yesterday
Format : DATE Field Yesterday
- Till Yesterday : Used to View data having Past dates. User can set the YESTERDAYMINUS parameter value to get data till previous X days
Format : DATE Field Till Yesterday $(YESTERDAYMINUS) 0
- is empty : Used to View data for which date has no value
Format : DATE Field is empty
- is not empty : Used to View data for which date has some value
Format : DATE Field is not empty
- This week : Used to view data for this week only
Format : DATE Field This week
- This month : Used to view data for this month only
Format : DATE Field This month
- This quarter : Used to view data for this quarter only
Format : DATE Field This quarter
- This year : Used to view data for this year only
Format : DATE Field This year
- Last week : Used to view data for last week only
Format : DATE Field Last week
- Last month : Used to view data for last month only
Format : DATE Field Last month
- Last quarter : Used to view data for last quarter only
Format : DATE Field Last quarter
- Last year : Used to view data for last year only
Format : DATE Field Last year
- Next week : Used to view data for next week only
Format : DATE Field Next week
- Next month : Used to view data for next month only
Format : DATE Field Next month
- Next quarter : Used to view data for next quarter only
Format : DATE Field Next quarter
- Next year : Used to view data for next year only
Format : DATE Field Next year