date issue

[engr_farhanqadr]

Hi Folks,

I am stuck in problem, I have sales data from 1 Jan 2016. I have made tiers of weeks , I want to start the date from 2 Jan 2016 instead of 1 jan 2016 as it was Friday. i used the script   'T' & ceil(Day([date/time])/7) &' '& Month([date/time]) as SevenD,

please help me out.

Farhan

[sunny_talwar]

Not sure what the end goal is, but may be this:

'T' & Ceil((Day(Date) - 1)/7) &' '& Month(Date) as SevenD;

[engr_farhanqadr]

Sunny,

it created another tier as T0 for every month and put all month first date to it which I dont want I just want the tiers to start with 2 jan 2016 instead of 1st jan 2016. just one day ahead.

Thanks

[sunny_talwar]

How about April 1st? That is a Friday as well? Would you have T1 starting April 2nd for april?

[engr_farhanqadr]

Sunny,

I just want to start my data from 2 jan 2016. as T1 start from 2 to 8 jan then so on and on. nothing else. all other months date as usual. let me know if you know.

Thanks