Skip to Content
0
Former Member
Apr 05, 2013 at 10:17 AM

Help in UDF

18 Views

We have to convert a delivery schedule code to a delivery date. schedule code is a 3 digit number.

The delivery schedule is a 3 digit number - see below:

100-199 Monday

200-299 Tuesday

300-399 Wednesday

400-499 Thursday

500-599 Friday

600-699 Saturday

700-799 Sunday

If current date is 5th-Apr and the input delivery schedule codes are

126 then delivery date 8th-Apr

218 then delivery date 9th-Apr

Can anyone please guide on the above requirement?

Regards,

Malini