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
Did you know that you could export data from different SSRS Tablix into different excel sheets of a workbook?
Today I had a requirement from one of my customer to export data from two different tables generated out of SSRS reports into two different...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...