How to get the First Month of Quarter

[Karim_Khan]

Hi Team,

    Can we get the First Month of every quarter on the selection of Months?

Regards,

KK

[MayilVahanan]

Hi

Try like this

=Month(QuarterStart(Max(Date)))

or

=MonthName(QuarterStart(Max(Date)))

[Anonymous]

you have a listbox with months you select?

you want another listbox showing the first month of each selected month?

make Expression:

month(quarterstart(yourdate)) gives you month (or use date(quarterstart(yourdate),'yourformat') to Format as you require

you can also use this Expression in table

[Karim_Khan]

Dear But I have Fiscal Period ID will it work with this

[Karim_Khan]

By applying the above expression

=Num(Month(QuarterStart(vMonth))) 

its is giving me default Month Jan as 1 only.

But I want Dynamic First month of Quarter on selection of Month

[MayilVahanan]

Hi

What is the value in vMonth?

[Karim_Khan]

=right([Fiscal Period ID],2)

[MayilVahanan]

hi

Do you have any date, Year or Month Year Field?

I think, =right([Fiscal Period ID],2) gives month number, am right?

[Karim_Khan]

Yes Sir,I don't have any Date field

[parthakk]

Hi Karim,

PFA hope it helps you

Thanks

Partha