Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to convert the field TreatyPeriodStartDate from my csv into a date field, but this is not working.
could you please help?
Thanks & Regards,
Markus
You can use Date# to interpret the date and Date to format it.
Date(Date#(TreatyPeriodStartDate,'DD.MM.YYYY hh:mm'),'DD/MM/YYYY') as Date,
Date(left(TreatyPeriodStartDate,10),'YYYY-MM-DD') as Date_field
You can use Date# to interpret the date and Date to format it.
Date(Date#(TreatyPeriodStartDate,'DD.MM.YYYY hh:mm'),'DD/MM/YYYY') as Date,