textbox interval

air_wolf

hello,

I have the following situation:
a matrixbox: on the left some data, on the right the date.

I want to see in the right textbox the entire month only, like this:
"01.05.08 .. 15.05.08 ..30.05.08" and only one month.

I tried to use the SourceExpr from the textbox to do this but it seems impossible. the SourceExpr is:
PeriodFormMgt.CreatePeriodFormat(PeriodType,CurrForm.Matrix.MatrixRec."Period Start")

Dave_Cintron

Do you mean you want the dates at the top on the right? If so, the trendscape feature does this, so you should be able to do the same, and you may need to familiarize yourself with the Date virtual table and how to filter.

Of, if you're looking in the matrix itself, then where does the data come from?

air_wolf

trendscape is not working as I need. If I'm choosing week or month, it displays weeks or months (which is a correct behaviour).
I need something like a SETRANGE betweeng the first day and the last day of the month and on the top right to see only the filtered result, so the user cannot enter the data in a wrong month.
it's a shift assignation and if they are entering a shift for 14th of may in 2nd of june, it will be wrong. this is why I want to display there only the working month.