If Condition

Rank: #2926

Solved

Question

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

on 15th Jan

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

on 15th Jan

3 replies

Last reply on 15th Jan

Show thread

Hide thread

Rank: #88

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

on 15th Jan

Rank: #2926

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

March 31

30 June

September 30th

December, 31st

on 15th Jan

Champion

Rank: #272

Hi Kan2332,

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

on 15th Jan