-
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?
-
How to validate US dates stored as YYYY-MM-DD
I have several fields that have dates stored in the format above. If I run the built in function "Is Date", the dates all fail. Is there a date system setting I need to change, or create my own function? What date format does the "Is Date" function require?
-
Issue with dates being read as American dates
I am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When annotating the columns, I have specified the column to be a date column. Now ready to explore my data, most of the dates in the column have correctly loaded in format dd/mm/yyyy. However some have converted to format dd-MMM-yyyy…
-
How to convert unix timestamps to human-readable date?
Hi, Does any one know how to convert Unix timestamps to human-readable date? Example Unix timestamp: 1568732257 --> wanted format: 2021-09-17 14:57:37 (Year-Month-Date Hour:Min:Sec)