KnowledgeSync Ideas

Ideas for the KnowledgeSync software product including EventPaks.

SQLite unable to convert dates to JulianDay in Calculated Columns

Trying to do a datediff using two dates via API. Using the JulianDay calculation recommended by KS formulas. When doing so it returns a NULL. After investigating, JulianDay requires date as YYYY-MM-DD but the output of KS Date is MM/DD/YYYY. I am sure some level of SQL conding can do the conversion but the idea is to make this easier on the programmer, not harder.

  • b p
  • Jan 12 2024
  • Already exists
  • Attach files
  • b p commented
    03 Apr 18:29

    I would like to see an example of this being done. It is a customer need and closing out an issue without approproate documentation is cheating the system. I worked for over 8 hours trying to make this work and involved several resources who all struck out. Awaiting your documentation.

  • Admin
    Robert Brown commented
    03 Apr 18:22

    This can be done. Has to be a documentation issue.