Skip to Content
0
Former Member
Jul 28, 2005 at 12:51 PM

DATE_TO_WEEK() FUNCTION ??

117 Views

I would like to use the standard funtions DATE_TO_WEEK and WEEK_TO_1ST_DAY() in the routine. Can I use them?

This is my requirement. I would like to derive the weekday (ZWEEKDAY) from a calday (ZCALDAY). Both are Z objects, so automatic time conversion is not possible.

I was thinking of using the standard functions that we can use to build formulas. First convert the date into 'week' and from week, derive the 'first day of week'. Then i can substract the date from the first day to get the desired result...

Can we use these formlas? Or, do you know if there are any equivalent funtion modules?

Any other ways... Highly appreciated...

Gova