Quarter day number

[#1]

Hi,

I need to create a field which will present quarter day number.

In each quarter we have 98 days.

so, for example, 1/1/2014 will be day 1, 2/1/2014 will be day 2, 1/7/2014 will be day 1, 2/7/2014 will be day 2.

So , how do I create it?

Thanks,

[Agis-Kalogiannis · Accepted solution]

The following expression would give you the QuarterDay field, if added in the MasterCalendar

date(TempDate) - QuarterStart(TempDate) + 1 AS QuarterDay

I hope this helps.

Agis