Skip to Content
0
Former Member
Dec 13, 2009 at 03:41 AM

how to break range of dates into different months in mm/yyyy format

27 Views

See the following eg:

MaterialNo Validfrom ValidTo RecordNo Value

A100 01.01.2007 13.05.2007 1000 1150/-

14.05.2007 24.08.2007 1001 1550/-

Now I want to break these dates into mm/yyyy format based on a condition. If the date(day) 15th lies in the range of dates

then it should pick that Value.

The output should be in this format.

MaterialNo Validfrom ValidTo Date RecordNo Value

A100 01.01.2007 13.05.2007 012007 1000 1150/-

022007 1000 1150/-

032007 1000 1150/-

042007 1000 1150/-

A100 14.05.2007 24.08.2007 052007 1001 1550/-

062007 1001 1550/-

072007 1001 1550/-

082007 1001 1550/-