0
Answered

How to set a an Adapter in IdB to filter the "Offset" on days and not Hours

André van der Westhuizen 12 years ago updated by anonymous 9 years ago 3

The requirement is that accounts must be provisioned if they will the date commenced is less than 7 days:

I want to set "DateActive" to filter the offset against days.

I did see the following, but don't know how to configure the offset for days:

 
A Time value type is defined in the following manner:

[ws][sign]d|[d.]hh:mm[:ss[.ff]][ws]
 
<adapter name="TimeOffsetFlag"
  SourceColumn="DateActive"
  DestinationColumn="EmployeeStarted"
  Offset="10:00:00"
  EqualValue="True"
  GreaterValue="False"
  LesserValue="True"
  NullValue="False" />

The hint shows the format for the offset, specifically:

[d.]

eg

2.3:04:05

for 2 days, 3 hours, 4 minutes and 5 seconds.

Thank you very much Adam.

André,

Should this issue still be open?