Forums › Cached › Customization › Searches / List Views

This topic contains 2 replies, has 0 voices, and was last updated by rudler 8 years, 8 months ago.

  • Author
    Posts
  • February 17, 2016 at 3:48 pm #5352 Score: 0

    rudler
    • Contributions: 0
    • Level 1
    • ☆

    I have a need to find the # of days between a date field (i.e. {startdate}) and a particular date ( i.e. May 1, 2015). What’s the trick?
    This is a cached copy. Click here to see the original post.

  • February 17, 2016 at 3:55 pm #5353 Score: 0

    errol
    • Contributions: 0
    • Level 1
    • ☆

    Below should do the trick:

    Code:
    to_date(‘05012015’, ‘MMDDYYYY’) – {startdate}
    -Errol

  • February 18, 2016 at 5:30 am #5354 Score: 0

    rudler
    • Contributions: 0
    • Level 1
    • ☆

    Thank you!!!

  • Author
    Posts

You must be logged in to reply to this topic.