Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Date Syntax Affects Counting Days?

Crystal 10:

Dates appear as 20,071,220 on report so I use this formula: NumberVar input := {CTCITE.cit_filed_date};

If input < 19590101 then Date (1959, 01, 01) else

Date ( Val (ToText (input, 0 , "") [1 to 4]),

Val (ToText (input, 0 , "") [5 to 6]),

Val (ToText (input, 0 , "") [7 to 8]) )

and this makes it appear as 12/20/2007 on my report and that works fine. My problem is now I want to count the number of week days between and . I don't know how to write formula that will calculate and display the number of weekdays excluding (Saturday and Sunday). I get error saying "date is required" when I try to do datediff formula.

Former Member
Not what you were looking for? View more on this topic or Ask a question