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 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,
As an idea you could try something based upon,
var now = new Date(); var year = now.getFullYear(); var month = now.getMonth();
How does that work for you?
Regards
Oren
Thank you everyone! While orignally I used the extraction option which worked well, I then switched over to Mr. Helmut Barro's solution of using Round up/down date.
Works like a charm
Thanks again
Jonathan Nelson on
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