I found a solution for my date problem in Crystal reports after 15 days of investigating.
The Date function of Crystal Reports requires arguments of year, month and day in that order as Date(y,m,d). But the Date function fails if there are special cases.
The dateserial function behaves in a similar way to Date function but is more tolerant
For example a value larger than 12 or less than one will still calculate a valid month, and will adjust the year correctly if DateSerial(y,m,d) is used.
Days work in a slightly different way. A value of 0 gets the last day of the previous month. This makes sense if you think that 1 gives you the first of the month, so 0 must get the day before.
For more information on functions in Crystal REports you can visit here
Subscribe to:
Post Comments (Atom)
Navigating the Data Science Seas: A Journey with Microsoft Fabric
Data science is a vast and exciting field, brimming with the potential to unlock valuable insights. But like any seafaring voyage, navigatin...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
-
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
-
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
1 comment:
Good One....
Post a Comment