1. UNIFYBroker Forum
  2. Questions
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" />
Adam van Vliet 12 years ago

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.

André van der Westhuizen 12 years ago

Thank you very much Adam.

Shane Day (Chief Technology Officer) 12 years ago

André,

Should this issue still be open?

Customer support service by UserEcho