Forum Discussion
Custom Time Period Names
Try something like:
newcolumn =
var yearnumber = mod(year[date],100)
var decembernumber = concatenate(yearnumber,yearnumber+1)
var jantoaprnumber = concatentate(yearnumber-1,yearnumber)
var summernumber = concatenate(yearnumber,yearnumber)
return if (month([date])=12,concatenate("Winter",decembernumber),if(month([date])<4,concatenate("Winter",jantoaprnumber),concatenate("Summer",summernumber))
First bit is basically defining the YYYY values, the second bit is looking at your month and then merging summer/winter to the YYYY value as appropriate
Try something like:
newcolumn =
var yearnumber = mod(year[date],100)
var decembernumber = concatenate(yearnumber,yearnumber+1)
var jantoaprnumber = concatentate(yearnumber-1,yearnumber)
var summernumber = concatenate(yearnumber,yearnumber)
return if (month([date])=12,concatenate("Winter",decembernumber),if(month([date])<4,concatenate("Winter",jantoaprnumber),concatenate("Summer",summernumber))
First bit is basically defining the YYYY values, the second bit is looking at your month and then merging summer/winter to the YYYY value as appropriate
Thanks. The logic in that makes sense to me but I'm getting a 'Token Eof expected' error when I'm trying to do it. I've got one date column called 'Date' that has the format of dd/mm/yyyy, would that be causing the issue?
That's probably just bad syntax on my part, it's probably missing a bracket or has an exra bracket somewhere
Thanks again. When I click on 'show error' it highlights the yearnumber variable name.
Managed to get this to work (a typo and a call to a table that didn't exist). But am getting very strange values now. So for instance 20/11/2012 comes out as Summer3333. See screenshot below: