6 Replies Latest reply: Jul 26, 2011 3:46 AM by Kaushik Solanki

# to find the existing year is a leap year

how can i find out that the existing year is a leap year. or how to calculate leap year

• ###### to find the existing year is a leap year

Hi,

Here is the formula.

=if(mod(Variable1,4) = 0 and mod(Variable1,100) <> 0 or mod(Variable1,400) = 0,'Leap','NotLeap')

Here Variable1 hold the year.

Regards,

Kaushik Solanki

• ###### to find the existing year is a leap year

means instead of variable1 i have to write year field or wat ????????

• ###### to find the existing year is a leap year

Hi,

Yes you can use the field.

But then you cant use the above expression in textbox, it should be used in a chart.

Regards,

Kaushik Solanki

• ###### to find the existing year is a leap year

i m using it at the back end:) and thank you and ny other logic realted to leap year

• ###### to find the existing year is a leap year

i want to ask any other logic through flags and what are these flags and why we use it

• ###### to find the existing year is a leap year

Hi,

You can use the same in backend too.

For example.

Data: