I am trying to do weekly reports using the FullLastWeek function. The problem is Crystal Reports doesn't recognised the date variable because it is in the wrong format, the problem is I can't seem to find what format the date is supposed to be in.
1. Do you know what the date format is suppsed to be?
2. If my variable is not in the correct format (which I cannot change now) is there a way in Crystal Reports that I can change the format of the date?
3. If number 3 above cannot be done, is there a work around to find the ranges between 2 dates (if the only date formats I am using is YYYYMMDD and DD/MM/YYYY), which I can report on.