Search results

  1. R

    Calculate 1st Monday of the month and no of days in a month

    Hi Everyone, I have to find the no. of days in a current month i.e 28,29,30 or 31 days. So that in a Calendar i can provide the input 'starting date' which is always be the 1st day of the month and 'end date' which will be last date of the month. I have to find the Mondays of a month. If...
  2. R

    Filter Collection with date range

    Hi Everyone, I have to select the data between a range of dates. In my collection there is a column name 'Date' which have a data in the format 'DD/MM/YYYY'. I am using below VBO. BO: Utility- Collection Manipulation. Action: Filter Collection. Condition which i have applied on the Filter...
  3. R

    Filter Collection with date condition

    Hi Team, In my process, I stored the data from excel into a collection using 'Get Worksheet As Collection'. In the excel there is column with name 'Date' in which values are of format 'DD/MM/YYYY'. And values in the 'Date' column can be of any month and year i.e approx 5000 records. Now i...
  4. R

    How to use Ole-Db VBO in BP version 5

    Hi Team, I have to use the Ole-DB Vbo in BP version 5. Can anyone please help me in making the connection with the excel. In Bp version 5 , there is no 'connection string' input field. So, how can i make the connection.
  5. R

    Sum the column value

    I have a process which will always be run on every Monday of the month. I have a excel sheet which have a 3 Columns, 'Balance', 'Status', 'Date'. I have to sum the value of the 'Balance' column based on the condition 'Status = Complete' and date = (1st day of the month to the last friday to the...
  6. R

    How get to know which monday is the 1st or 2nd so on

    Hi Team, I have a process which will always be run on every Monday of the month. Before running the 1st time on the 1st monday of the month, we have received a Excel file which have a single worksheet which contains some Vlook up tables. My requirement is that when it is running on 1st...
Top