Hi there,
Is it possible to somehow split a date into parts? Eg, I would like to get the year into one new column and the month into a new column.
How would I do this from a normal date column?
Thanks
Hi David,
You could convert your date to text and then use the 'Extract text' operator to split the date out to its various sub-components. If you need to perform calculations on your results you can use the 'Change data type' operator to convert the text to numeric values.
Not a very elegant solution but it will give you what you're after.
Regards,
Jonathan