Create an extract instead of live connection then you can find the Dateparse Function
or could you please tell me 1,509,745,851 in this value what is the year, Month and Day
with the help of LEFT(),RIGHT(),MID() functions you can extract the Year,Month and day
Use the function called MAKEDATE(year,month,day) with this you can convert to date
Hope this helps kindly mark this answer as correct or helpful so that it will help others
I have a dataset where the date comes in a numeric field, such as "1,509,745,851" - in this String can you tell us where should be the break for MM,DD,YYYY, etc is occurring?
Also, if possible can you take a sample of the field (10 random records) and upload it here so that we can help better. Thank you.
if it is a Unix timestamp, you can go with
DATEADD('second', 1509745851, #1970-01-01#)