Skip to Content
avatar image
Former Member

DateDiff Formula isn't Recognizing my Date/Time from my field

I am trying to find the ammount of days from a date invoiced to the current date. The Date invoiced field is in string format so when i try to use datevalue it says bad string format. I need some help here on converting it so it works correctly. current format is m(or mm)/d(or dd)/yy h(or hh):mm am(pm) so it would look like 6/19/17 6:45 PM or 12/6/17 12:04 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 31, 2017 at 02:41 PM

    Click the F1 key to bring up the CR help file and then search on Date functions.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I did this and I can't find anything convert those from text strings to number stings no matter what I try. The error thrown is that it is a bad string format

  • Aug 01, 2017 at 09:05 PM

    What is the string value example?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2017 at 06:48 AM

    Hi Cassie Benson,

    Use this formula it may be helpful for you.

    datediff ('d', {?Billing Period Start Date}, {?Billing Period End Date})

    Thanks Regards,

    Ramesh.P

    Add comment
    10|10000 characters needed characters exceeded