Experian Data Quality Community
-
Different date formats not being recognized as a date
What problem are you facing? Because the data is coming from many different sources the dates have different formats and when they are mixed up in one input it gets difficult to put them in the same format as they are not recognized as date datatype, so I would love to be able to just use the format date function and fix…
-
Date formats...
Earlier today I received the below email from a customer which I wanted to post on here in case the answer is of use to others: I was wondering if you could help me overcome an issue I have been facing in Aperture. When uploading a file to Aperture through the “Add Dataset” section, in the “Define settings” menu there is a…
-
Get the 6 month Older Date from Today
Is there any easy way to get the date which is 6 months older than today?
-
Batch timestamp format
I've created a number of DQ outputs running of a scheduled workflow to create a multibatch dataset of results over time. Unfortunately the batch timestamp although referenced as date/time, is not read as date time by excel or Power BI. Is there a format setting so that batch timestamp can be seen as date format in other…
-
Created date columns
Created date columns. They converted to alphanumeric. When I try to perform a compare date/time of the two newly created columns, the error is "Not a date". Can the new columns be converted to 'date' datatype?
