08-20-2018 03:24 AM
Hi I have a data service that produces a datum colum which looks as follows:
When I try to match the input as variables as:
I get an invalid date message in my Custom Attribute colum (for extracting Year for example)
And I get 'Wrong date format or attribute' when trying to create a time dimension based on this field.
I suspect that the two letters T and Z are the cause is there any way without changing the input data to get this to work?
Solved! Go to Solution.
08-20-2018 04:21 AM - edited 08-20-2018 04:22 AM
this post should be relevant to your use case:
08-20-2018 04:48 AM
I had seen that information, but it is not working for me. All values are filled (each row has a valid date in the same format), so far I can see my pattern is the same as the content, but still it does not work.
I have tried many differend options but none of them work.
In your 2nd link there is a exsample of a variable for strictIsoParse, this is exactly the format of my datetime colum, but it does not work in the BI wizard either as custom attribute or time dimension.
var strictIsoParse = d3.utcParse("%Y-%m-%dT%H:%M:%S.%LZ");
09-28-2018 05:59 AM
Hi Is there any aditional information available today I got confronted with the same problems again.
When I have a colum combining the datum and time it does not work, when I have a colum with only the datum it does work. But that is not enough for the intended M.app.
10-19-2018 05:09 AM - edited 10-19-2018 05:10 AM
Dennis found the issue to be the date values had a leading space character that was not being accounted for with the date/time variables.
For date/time format issues please refer to the document Stefano has linked above and if no resolution is forth coming from that contact support.