Basic Date Time Operations

Date Time Operations provide functionalities to find

1. First Working Day by subtracting particular Days from a specified Date using Calendar Entity Data.

2. Last Working Day by Adding particular Days from a specified Date Calendar Entity Data

3. To get number of days on difference between of two Dates.

4. To ‘Day of the Week’, ’Day of the Month’, ‘Day of the Year’ for specified Date.

Execution of the each function or operation of above specified requires different set of Input and output properties.


Execution Steps of Workflow

· Write the Source code and register the dll file using plugin registration tool.

· Go to “Processes” Entity and create new process by clicking on NEW. 

clip_image002[10]

· Enter Process Name, Select category as Workflow, Select Entity on which you wish to fire and Check Type as New blank Process. Click on Ok.


clip_image004[5]

 

· Check “START WHEN”, this decides when your workflow should fire.

clip_image006[5]

 

· Click on Add Step, select your workflow.

· Add another step “UPDATE RECORD” for output to display. This displays the output when the record is updated.

clip_image008[4]

 

· Now Click on Set Properties to set input and output properties.

· Activate the Process by clicking on “Activate ” button.

 

1. Last Working Day Operation

For execution four input properties and one output property is required

Input Properties: 
1. Field with Date Type as first Input parameter to take date.
2. Field with Whole Number Type or Constant / Fixed Value as second Input parameter to specify the number of days.
3. Field with Whole Number Type or Constant / Fixed Value as third Input parameter to specify the number of Hours.
4. Field with Whole Number Type or Constant / Fixed Value as fourth Input parameter to specify the number of Minutes.
Output Properties:
1. Field with Date Type as Output parameter to set date.

 

· Select the required entity and fields and then click Add then OK.

clip_image010[4]

 

· Select the field which displays output and set workflow into it by clicking on entity fields and click add and then ok.

clip_image012[4]

 

· This completes the setting of input and output properties.

· Now go to entity forms and provide input values and click on save.

· Check into system jobs entity to know whether the workflow got succeeded or not.

 

2. First Working Day Operation


For execution four input properties and one output property is required

Input Properties: 
1. Field with Date Type as first Input parameter to take date.
2. Field with Whole Number Type or Constant / Fixed Value as second Input parameter to specify the number of days.
3. Field with Whole Number Type or Constant / Fixed Value as third Input parameter to specify the number of Hours.
4. Field with Whole Number Type or Constant / Fixed Value as fourth Input parameter to specify the number of Minutes.
Output Properties:
1. Field with Date Type as Output parameter to set date

· Select the required entity and fields and then click Add then OK.
clip_image014[4]

 

· Select the field which displays output and set workflow into it by clicking on entity fields and click add and then ok.

clip_image016[4]

 

· This completes the setting of input and output properties.

· Now go to entity forms and provide input values and click on save.

· Check into system jobs entity to know whether the workflow got succeeded or not.

 

3. Difference of Two Dates


For execution two input properties and one output property is required

Input Properties: 
1. Field with Date Type as first Input parameter to take date1.
2. Field with Date Type as second Input parameter to take date2.

Output Properties:
1. Field with Whole Number Type as Output parameter to set Days.

· Select the required entity and fields and then click Add then OK.
clip_image018[4]

 

· Select the field which displays output and set workflow into it by clicking on entity fields and click add and then ok.

clip_image020[4]

 

· This completes the setting of input and output properties.

· Now go to entity forms and provide input values and click on save.

· Check into system jobs entity to know whether the workflow got succeeded or not.

4. Day of the Week, Month and Year


For execution one input properties and three output property is required

Input Properties: 
1. Field with Date Type as first Input parameter to take date.
Output Properties:
1. Field with Whole Number Type as first Output parameter to set Day of Week.
2. Field with Whole Number Type as second Output parameter to set Day of Month.
3. Field with Whole Number Type as third Output parameter to set Day of Year.


Select the required entity and fields and then click Add then OK.
clip_image022[4]

 

· Select the field which displays output and set workflow into it by clicking on entity fields and click add and then ok.
clip_image024[4]

 

· This completes the setting of input and output properties.

· Now go to entity forms and provide input values and click on save.

· Check into system jobs entity to know whether the workflow got succeeded or not.

The Basic Date and Time solution download here:    Download

No Comments

Add a Comment

  1. (max length 2000)
  2. captcha refresh captcha