Sequel Viewpoint Date function ver 11.16

Tags:
calculating dates
date function
Scripts
How do I script the current date -14 days to use as a variable?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    A "variable"? The "variable" would be used how? Without knowing how it's expected to be used in "Sequel", an answer won't be obvious. Also, is "Sequel" the ASC SQL-like product or something else?
    35,000 pointsBadges:
    report
  • Subhendu Sen
    Probably you are using Helpsystems Sequel Viewpoint. If yes, you can go their official website and search for help. Here is a link, that may be a helpful: https://community.helpsystems.com/knowledge-base/showcase-knowledge-base/showcase-9/understanding-date-functions/
    138,560 pointsBadges:
    report
  • ToddN2000
    Post the code you have tried so we can better understand what type of code you are using. SQL come in a lot of varieties and have slight variances.
    132,520 pointsBadges:
    report
  • brstewartmcskms

    (CAST(A.CHECKDATE AS DATE) > CAST(CURRENT DATE -14 DAYS AS DATE)) 

    This is the SSMS code - trying to make it work in Sequel Viewpoint and get the same result. 

    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: