Hi,
I have problem with Dateparse function.
It works on one source (Excel), but when try to use it connecting to same dataset loaded to Google BigQuery function is unknown.
I have Year as number, and Month name as String.
I'd like to create Date dimension.
Formula created and working on Excel source:
DATE(DATEPARSE("yyyy/MM",STR([Year])+"/"+STR((IF [Month Name] = "January" then 1
ELSEIF [Month Name] = "February" then 2
ELSEIF [Month Name] = "March" then 3
ELSEIF [Month Name] = "April" then 4
ELSEIF [Month Name] = "May" then 5
ELSEIF [Month Name] = "June" then 6
ELSEIF [Month Name] = "July" then 7
ELSEIF [Month Name] = "August" then 8
ELSEIF [Month Name] = "September" then 9
ELSEIF [Month Name] = "October" then 10
ELSEIF [Month Name] = "November" then 11
ELSEIF [Month Name] = "December" then 12
END))))
If I will remove Dateparse, keep only
STR([Year])+"/"+STR((IF [Month Name] = "January" then 01
ELSEIF [Month Name] = "February" then 02
ELSEIF [Month Name] = "March" then 03
ELSEIF [Month Name] = "April" then 04
ELSEIF [Month Name] = "May" then 05
ELSEIF [Month Name] = "June" then 06
ELSEIF [Month Name] = "July" then 07
ELSEIF [Month Name] = "August" then 08
ELSEIF [Month Name] = "September" then 09
ELSEIF [Month Name] = "October" then 10
ELSEIF [Month Name] = "November" then 11
ELSEIF [Month Name] = "December" then 12
END))
and will try to convert type to Date, after adding to viz, Google BQ says that '2015/5' is invalid date.
Any reason why Dateparse do not work?
Is there a way to have workaround?
