Determining Dates

[#1]

Hi all,

i have the following task:

I have a record in a table that describes a week. It has one field for each day of the week. the record has a start day (always Sunday) and the record has an end date (always Saturday😞

ID	start	end	monday	tuesday	wednesday	thursday	friday	saturday	sunday
12	2010-05-16	2010-05-22	2	1	5	2	5	0	0

How can i for each weekday in a record determine the date based on start and end field ?

Thanks a lot!

[CELAMBARASAN]

Hi,

     Each weekday means ?Determining start and end of the given date?

     Example:

     For 2010-05-20 you need to retrieve 2010-05-16 and 2010-05-22.

Celambarasan

[#3]

Hi, sorry for beeing unclear.

The value in the field 'start' is the date of the Sunday.

The value in the field 'end' is the date for the Saturday.

Based on this, i would like to determine the dates for the other weekdays in a record.

in the example above this would be:

2010-05-17 for monday

2010-05-18 for tuesday

...

Thanks a lot!

[CELAMBARASAN · Accepted solution]

Hi,

     Then try with this

     Date(Start+1) as Monday

     Date(Start+2) as Tuesday like that so on.

If it didn't help let me know.

Celambarasan

[jagan]

Hi,

You can use

Start+1 AS Monday,

Start + 2 AS Tuesday,

'

'

'

Regards,

Jagan.