Skip to Content
0

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

Jul 28, 2017 at 10:32 PM

47

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Don Williams
Jul 31, 2017 at 02:41 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0
Don Williams
Aug 01, 2017 at 09:05 PM
0

What is the string value example?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 07, 2017 at 06:48 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded