Welcome to

Welcome to!

This site was created as a place to share stories, tips, and troubleshooting help with ShoreTel/Mitel systems. ShoreTel/Mitel is obviously the MOST exciting VoiP platform on the market right now, and we realized there was no centralized place to discuss this platform, but now there is. Please feel free to join and share your experiences.

Please Note: This site IS NOT owned, funded, or managed by ShoreTel/Mitel, Inc. although you may find ShoreTel/Mitel employees sharing there experiences and expertise. If you would like more information on ShoreTel/Mitel systems, contact BTX at [email protected]

As always please support the advertisers that help support our site.

Thank You,
See more
See less
  • Filter
  • Time
  • Show
Clear All
new posts

  • Decision question in CCS

    Is there a way to use a comparative on a date field? example:

    if {orderdate} <= {shipdate} then blah blah else blah blah.

    For types in the decision, it appears I can only use number or string. The decision does not work correctly when either of those are chosen. Of type date is not an option.

    If it does not work, does anyone have an idea of how to get around. Is there anything I can do with a SQL execute? IE - in the sql say if {orderdate} <= {shipdate} then {datecompare}=1 else 2. I could then do a decision based on that. if {datecompare} = 1 then blah blah, else blah?


  • #2
    Try this as your SQL: SELECT ({orderdate} <= {shipdate}) AS DateCompare;

    True should result in 1, false in 0. If this does not work, tell me what type of database you're running it against (MySQL, MS SQL, etc.) and I may be able to help, as each vendor has their own dialect of SQL.