find out current period

[hopkinsc]

i have a field ' Reporting Period'

how would i find out todays reporting period?

thanks

[hopkinsc]

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

[hopkinsc]

hi, no sorry, that didnt work

[hopkinsc]

i have attached a sample.

I want to display the reporting period in the text box without making any selections.

Thanks

[hopkinsc]

does anyone have any ideas please?

[#6 · Accepted solution]

Hi,

you are searching for something like this:

=only( {< [Reporting Date] = {"$(=today())"} >} [Reporting Period] )

It works, have fun.

Best

Sacho Alexander Josachkoff

[hopkinsc]

Thanks very much, that's exactly what i was looking for