DTEDIFF(I,DT1,DT2)

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Wolfgang
Posts: 60
Joined: Tue Oct 10, 2017 12:44 pm

DTEDIFF(I,DT1,DT2)

Post by Wolfgang » Wed Jun 28, 2006 3:12 pm

Hello,__when I use DTEDIFF(D,ctod("01.01.2000"),ctod("01.01.1601")) it works fine, but when the year of the dates DT1 or DT2 is equal or below 1600, DTEDIFF(D,ctod("01.01.2000"),ctod("01.01.1600"))then I get only ***************. How can I check if this happens?__DTEDIFF(D,ctod("01.01.2000"),ctod("01.01.1601"))= "*******" will not work.__Thanks__Wolfgang
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: DTEDIFF(I,DT1,DT2)

Post by kfleming » Fri Jun 30, 2006 7:34 am

The date range that we currently support is 03/01/1600 to 12/31/2999 so date fields earlier than 03/01/1600 will show as error values I am afraid.____Kathleen__R&R Support
Top
Post Reply

Return to “R&R ReportWorks Users”