Learn, collaborate and solve problems with like-minded data quality enthusiasts.
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…
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…
Is there any easy way to get the date which is 6 months older than today?
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. 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?
