Date format for week in Transformer

[bencri]

When using the date wizard in Transformer, you can automatically get te week based upon a date. Is it possible to change the format in such a way that you get the weeknumber rather than te standard date-format because tihs doesn't really make sense.

 

[ianhawksey]

I have not been able to change the format automatically. I usually bring the date columns required into the model from another datasource (eg XLS), where the week is already numbered. Alternatively you can always manually change the category label name.

If anyone knows another way I would be interested to know.

Hope this helps

Ian

 

[ianhawksey]

I have not been able to change the format automatically. I usually bring the date columns required into the model from another datasource (eg XLS), where the week is already numbered. Alternatively you can always manually change the category label name.

If anyone knows another way I would be interested to know.

Hope this helps

Ian

 

[ADB1]

Don't know if this is what you are looking for....

However, we never use the date wizard in any reports. We have a calendar table on our database which contains data up to 2011 in columns such as day name, week number, month name, day number, year, etc. etc. We join to the production tables on any date column to a columns on the calendar called actual date, this column is simply a large list of dates i.e. 01/01/01 through to somewhere in 2011.

All of our time dimensions are sourced from this view.

Cheers,

Adam.