Dear all

How can I get year and week from transaction date ? Is there any function I can used it ?
Please help me !!!! thank's

Hi,

Can you give us an example of your transaction date that you want to take from it the year/week. Meanwhile, you can check the following list of date functions:
http://www.baanboard.com/programmers_manual_baanerp_help_functions_date_time_zones_synopsis

I hope it helps,

- George

Hi George,

Thanks for your answer, ok I will give you sample for transaction date.
I was making a productivity report, I want to table tdltc001.oudt (lot date) related to table tihra100 (year and week). So I want to know how many week or year the lot have been done.

Thanks

Yadhi

Hi,

Use the num.to.week() function (http://www.baanboard.com/programmers_manual_baanerp_help_functions_date_time_zones_num_to_week). Here is an example:

| the input is tdltc001.oudt
num.to.week(tdltc001.oudt,week_dayno,year_dayno,weekno ,yearno)
| the number of weeks will be stored in weekno
| the year will be stored in yearno
I hope it helps,

- George

Hi... george,

Your sample give me, it is help me. I try and success........ thank you very mach george...... see you



regards

yadhi