Announcement

Collapse
No announcement yet.

Custom Field (Difference between two dates)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Custom Field (Difference between two dates)

    How would I handle this, in the database I have

    date_started, date_finished

    I'd like to have the date difference between the two fields as a separate column.

    So:

    date_started | date_finished | days_to_complete

    What's the best way to handle this in Scriptcase?

  • #2
    Hello,

    You can use SC's macro sc_date_dif to handle it.

    For more info: http://downloads.scriptcase.com.br/d...tm#sc_date_dif

    If it was the case which sc_date_dif didn't existed, and you could handle it perfoming a SELECT on your RDBMS, you could use sc_lookup macro to run any SELECT statement.

    See more: http://downloads.scriptcase.com.br/d....htm#sc_lookup

    regards,
    Bernhard Bernsmann

    Comment

    Working...
    X