we have created a basic report for a client, and the date shows the dd/mm correct, but the year is 1899?
Any ideas?
(Please visit the site to view this file)
we have created a basic report for a client, and the date shows the dd/mm correct, but the year is 1899?
Any ideas?
(Please visit the site to view this file)
Hi,
What is the date for the record directly in the database? Are you using any calculations on that date field? or is it simply returning the column from the database?
Hi, I have just had another look at it. It is returning the date 30/12/1899 for ALL of the transactions selected. It should be the won date, which are all 18/01/2013
Is the report being run on the server, or on a client?
Is the report being sent to screen, or exported to excel?
Can you share the view you have written for this report?
being run on a client
Sent to screen
the source view is "vestimatereporting" Which we have created for them.
the crm guys have said that there is no data in the field, and that is why is returning the SQL system default date for all dates. But this doesn;t seem to be correct, as it is only wrong in the chart, not in the list on the report.
looks like it may be that the report is corrupt. I have created a similar report, and the field displays correctly!! Thanks for your help :)
It was actually that the field was a date only field, and the date functions on a chart only work with date/time fields
*Community Hub is the new name for Sage City