I am trying to make a worksheet easier to use instead of using excel and a calculator. I have in the first cell 3900.00 and add 47,025.50 to get 50,925.50. I do this on a monthly basis. Next month I may have 3900.00 (same amount again) but it will not update the mtd or ytd total. Is there a...
I have created a form ("quiz"). I have this quiz sent to me via email when it has been completed. I have answers that are true or false and then 3 questions require text messages. My question is how do I or can I specify the text to show up when the quiz is submitted? Ex. first...
I think I'm almost there!! But I believe somewhere the syntax is wrong, Help!
Datediff(NumberToDate(ToNumber({DH_DOCUMENT.DH_ISSUED_DATE}),NumberToDate(ToNumber({DV_DOC_APPROVAL.DV_READY_DATE})))
Yes, the field is string. I'll try getting the NumberToDate, and see if that works.
I have tried the DateDiff function too. It keeps telling me that it wants an actual date, I want to use the fields.
Thanks!
I have a report that shows the start date and the end date for each record. These 2 fields come from seperate tables, the data type for each is string, 8, format, yyyymmdd (20020402). I need to get the duration between these 2 dates. How is this best accomplished in CR 8.5. Thanks in advance...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.