Converting dates

[#1]

How do you separate a date in the format YYYYWW (i.e 201432) to year, YYYY (2014) and date WW(32)?

[Anonymous · Accepted solution]

if your field is a string (as I believe) and not a date, you can use left(fieldname,4) for year and right(fieldname,2) for week, even from your load script to optimize your ram usage.