Forum Discussion
Date Format contains random numbers in Report Builder
Hi JayneBeetham ,
Check the Field Data Type in Report Builder:
Open the Dataset. In Report Builder, go to the Report Data pane (on the left side) and locate your dataset.
Inspect the Field's Data Type:
Right-click the dataset and select Dataset Properties.
Under the Fields section, find the field you're interested in.
Right-click on the field and choose Properties.
Check the Data Type:
In the Field Properties window, check the Data Type property. This will tell you whether the column is recognized as a date, string, integer, etc.
Hope this helps.
Chaithra E.
Unfortunately this hasn't resolved it:
Community SupportHi JayneBeetham ,
Make sure that the Date_Field in your dataset query is a DateTime type. If your dataset is SQL-based, run the SQL query and ensure the field is returned as a true DateTime. If you're using a CSV or Excel file, double-check that the column isn’t being read as a string.
Wrap the field in CDate() as previously suggested, but using this syntax:
=Format(CDate(Fields!Date_Field.Value), "dddd dd MMMM yyyy")
if you're sure the field is already DateTime:
=Format(Fields!Date_Field.Value, "dddd dd MMMM yyyy")
Hope this helps.
Thank you.
Hello,
Thank you for your help. Apologies for late reply, I am onl able to work on this project a little each week as it's something I'm doing to upskill myself in between my regular work.
I used your first option as I cannot be confident the field is formatted as a date in my dataset which produced this:I then tried your second solution and it gave the same.