Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a field ' Reporting Period'
how would i find out todays reporting period?
thanks
Hi,
you are searching for something like this:
=only( {< [Reporting Date] = {"$(=today())"} >} [Reporting Period] )
It works, have fun.
Best
Sacho Alexander Josachkoff
hi, sorry, in my calendar i have dates, periods, quarters etc
I don't want to work the period out as the periods are already in my data.
so todays date =
30/05/13 and the period is 5
So i want to display (in a text box) the current period (without making any date selections)
my fields are :
Reporting Date
Reporting Period.
Does that make sense?
Thanks
hi, no sorry, that didnt work
i have attached a sample.
I want to display the reporting period in the text box without making any selections.
Thanks
does anyone have any ideas please?
Hi,
you are searching for something like this:
=only( {< [Reporting Date] = {"$(=today())"} >} [Reporting Period] )
It works, have fun.
Best
Sacho Alexander Josachkoff
Thanks very much, that's exactly what i was looking for