correct use of the date_get in the expression buillder
Hi, having looked at previous forum post on the topic i may have missed something.
I am trying to extract from a date-tim4 field(yyyy,MM,DD) , 3 new columns - Year, Month as a number , week number.
Previous posts show for instance the method as - date_get(Date, DATE_UNIT_YEAR,"Year") - I assume where Date is the column header. and "Year is the new Column holding the year data".
If someone could point me at the correct syntax I would appreciate it
Thanks
I am trying to extract from a date-tim4 field(yyyy,MM,DD) , 3 new columns - Year, Month as a number , week number.
Previous posts show for instance the method as - date_get(Date, DATE_UNIT_YEAR,"Year") - I assume where Date is the column header. and "Year is the new Column holding the year data".
If someone could point me at the correct syntax I would appreciate it
Thanks