Hello webMethods Expert,

I am trying to build a service which to scan all the transaction for the past 1 hour or 30 minutes until now.
Basically for this service i have 2 inputs:

• start_date = last 1 hour or 30 minutes from now
• end_date = current date time

For the “end_date”, i can use: pub.date:getCurrentDateString
But i am still doubt, how can i construct “start_date” which is current datetime minus 1 hour or 30 minutes from now?

I don’t think the service pub.date:calculateDateDifference can do this either.

Any idea on built in services to construct the “start_date”?

Appreciate any help.

Thank you,
Fanny T

Hi,

You should look into the “webMethods Integration Server Built-In Services Reference” manual.

pub.datetime:increment

WmPublic - Increments or decrements a date and time by a specified amount of time.

Happy coding.

Hi Gerardo,

Looks like i am still referring to the Software AG built in Services Reference Version 9.5 SP1.
I don’t see the incrementDate in this document.

Since i am using Version 10.3, i can see this service in WmPublic.
pub.date:incrementDate.

Many thanks for pointing this service.

Best Regards,
Fanny T

Hi,
There are a few steps to build a flow service which you may need, like below:

1. build a service with
   service Input = minutes_offset
   service output = start_date, end_date

2. invoke pub.date:getCurrentDate
   

   https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/58b2f86089de27084e336215f64eae028dc5c498_2_1035x127.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/58b2f86089de27084e336215f64eae028dc5c498_2_1380x170.png 2x" data-dominant-color="F7F8F9">

   image1510×187 41.4 KB

3. invoke pub.date:formatDate, to get yyyy(year), MM(month), dd(day), HH(hour), mm(mins)
   

   https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/eca878940529598bdec4a8e2fe70aa34cf83f018_2_1035x265.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/eca878940529598bdec4a8e2fe70aa34cf83f018_2_1380x354.png 2x" data-dominant-color="EEF1EC">

   image1437×370 74.9 KB

4. invoke pub.math:addInts, add mm with minutes_offset (30mins or 60 mins)
   

   https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/4724521be56a63a8cbc9f992bc8185d79995e04b_2_1035x213.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/4724521be56a63a8cbc9f992bc8185d79995e04b_2_1380x284.png 2x" data-dominant-color="EEF2ED">

   image1450×300 52.2 KB

5. invoke pub.date:formatDate to get end_date, pattern = yyyy-MM-dd HH:mm
   

   https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/374844730f16a3865a6671f408b9f5d122e684d1_2_1035x268.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/374844730f16a3865a6671f408b9f5d122e684d1_2_1380x358.png 2x" data-dominant-color="F8F9F9">

   image1522×397 83.3 KB

6. invoke pub.date:dateTimeBuild to get start_date, pattern = yyyy-MM-dd HH:mm
   

   https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/d8d7406791ebcde1c5a3accd18ef65cee8db8035_2_1035x258.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/d8d7406791ebcde1c5a3accd18ef65cee8db8035_2_1380x344.png 2x" data-dominant-color="F6F7F7">

   image1462×365 82.2 KB