16
Views
4
Comments
Solved
If Condition
Question

How to write a (if) condition for it to work - 1,4,8,12 months

Rank: #88
Solution

Hi Kan2332,

you can use built in function Month to get month from date/datetime variable

and write condition like below-

If(Month(CurrDate())=1 or Month(CurrDate())=4 or Month(CurrDate())=8 or Month(CurrDate())=12 ,True,False)

Hope this will help you.

Regards

Rahul

Rank: #88

provide the information where you apply this and what error you getting.

Rank: #2926

Sorry, you can write how to remake your condition so that it was - 

March 31

 30 June 

September 30th 

December, 31st

Champion
Rank: #272

Hi Kan2332,

Could you please explain in more details what you want to achieve?