Working with DATE in a BRE.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Working with DATE in a BRE.

Viewing 1 reply thread
  • Author
    Posts
    • February 7, 2007 at 5:39 AM #17588
      community-content

        I think it should be possible to work with date's in the BRE. Just don't know how.

        We want to check if a given date is between a periode of 26 weeks before sysdate and 26 weeks after sysdate.

        Anyone who has expirienced with this?

        Thanks for any help.

      • February 7, 2007 at 10:22 AM #17594
        community-content

          Hey there,

          The BRE has a predicate called "between" that compares two datetime variables. There's also a "before" and "after" predicate that looks for valuesbefore and after a specified date. I've often used helper components in the BRE to turn strings into dates, and also pass in a date, add a value (like 26 weeks), and then use the return value in concert with the provided predicate functions.

          That make sense?

          • February 7, 2007 at 11:34 PM #17604
            community-content

              Hello Richard Seroter,

              Thanks for your reply, it sure makes sense.

              We have tried the "between", "before" and "after" predicates.

              Have been struggeling to get the right DATE-format for the values to check, but we never changed the date that we would like to check from STRING-format to DATE-format.

              I will try this later on this or next week and let you know about the results.

              • February 21, 2007 at 4:17 AM #17743
                community-content

                  Have tried a few things, and nothing seems to work.

                  The schema that I receive has a date in it, format is <Datum>2007-02-21</Datum> and type is xs:date.

                  How to check this in the Business Rule Engine and let the BRE change a boolean if date is more than 26 weeks (182 days) from SysDate.

                  Any help will be appreciated.

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.