Filter/View

Date Operands in Orcanos

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

Related Articles