Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was wondering if I could get some help please.
The date in my pivot table should display 11/10/17 but instead I am getting the below result.
Kind regards,
Esther
what is your source data date format? Try using Num(Floor(YourdateField)) OR Date(Date#(yourdatefield, 'yoursourcedateformathere'))
Maybe...?
Date#( FieldName, 'MM/DD/YYYY') as Date
If you could share your data field or qvw file, makes easy to help you.
1. If that field lies in expression then, go to chart properties--.>Numbers--> select date format for specific expression.
2. if that lies in dimension then make it as Date(field name).
Hope It works.
Hi,
'1033176:00:00' is the result of formatting the date '11/10/2017' to show only hours:minutes:seconds.
Either change the number format in your pivot table or use Date(YourValue) to format your value as date.
hope this helps
regards
Marco
Hi,
you can try this converting number into date purpose
Date(Num#(from_date,'####()'), 'dd/mm/yyyy') as newDate
The Field your referring in screen shot is Time not a date i believe.
Please check your data source and check which field are you looking to convert.