Using Desktop version 10.0
I have tried doing DATEPARSE but it doesn't recognise. I would like to convert it from string (Year Month) to Date with adding the first date of each month ( example of the first record- 01/04/2017) please.
4 answers
Mubasher Shah wrote:
it does not recognise the 'DATEPARSE' word nor is it in my list when creating a calculated field, I have also tried MAKEDATE again similar situation (unrecognisable).
As per the documentation for dateparse;
Note: This function is available for non-legacy Excel and text file connections, Google Sheets, MySQL, Oracle, PostgreSQL, and Tableau extracts.
and
If the DATEPARSE function is not available for the data that you're working with, or the field you are trying to convert is a number data type, you can use the DATE function instead.As per the documentation, use DATE instead i.e. DATE(left([Year Month],4) + "-" + right([Year Month],2) + "-1")
