Date Mapping given a year, week number and day

[Former Member]

Is there any straightforward way to calculate a date given a year, week number and day?

For example 2005 wk 50 day 7 equates to 24-Dec-05.

Is it possible to do this using the standard functions in a message map, or do I need a custom function?

Regards

C

[Former Member]

Hi Chris,

You need to develop a custom function which accepts all the inputs you are providing and then return the date in the required format.

If you are having a specific date then using DateTrans you can only transform it to a specific format but not calculate it based on a week value.

Cheers

JK