Open for Voting

Date manipulation in live transaction

Hi Guys,

One of the challenges we regularly face when running transactions it date fields for example booking a flight you can only do typically 12 months in advance or insurance you can only buy to start int he next 2 months. It would be really handy if in the text field you could use some macro to do basic arithmetic and date functions so you could for example dateadd(d,getdate(),2) would return a date 2 days from now ans use that in the field. I think we would probably need to implement at least the following macros

getdate

dateadd

month

year

day

and some kind of date formatting function so you can format the results correctly for the txt field you are completing

JonG

FormerIdeaCreator
Parents


  • I would even genericize this request further.  We need the ability to place variables into the transactions and have the ability to manipulate those variables based on external factors.

  • in reply to emarksrpi86

    Can you provide few examples of such variables, situations on which you would use it and how would the workflow look like?

  • in reply to peter.kruty

    One example would be  today's date - call it ${date)

    One of the health check's I've written looks at a status page for the word "completed" and then  looks for "${date}"  to see if tonight's batch processing has completed for today.

    Since I can only hard code items, I currently have to update the check in the recording on a daily basis.

    Another check would use a variable called ${Financial_Institution} so I can run against multiple sites and check for that institution's name on the site so I can alert when it appears.

Comment
  • in reply to peter.kruty

    One example would be  today's date - call it ${date)

    One of the health check's I've written looks at a status page for the word "completed" and then  looks for "${date}"  to see if tonight's batch processing has completed for today.

    Since I can only hard code items, I currently have to update the check in the recording on a daily basis.

    Another check would use a variable called ${Financial_Institution} so I can run against multiple sites and check for that institution's name on the site so I can alert when it appears.

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.