how can i find out that the existing year is a leap year. or how to calculate leap year
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.
means instead of variable1 i have to write year field or wat ????????
Yes you can use the field.
But then you cant use the above expression in textbox, it should be used in a chart.
i m using it at the back end:) and thank you and ny other logic realted to leap year
i want to ask any other logic through flags and what are these flags and why we use it
You can use the same in backend too.
if(mod(Variable1,4) = 0 and mod(Variable1,100) <> 0 or mod(Variable1,400) = 0,'Yes','No') as Leap Year
Retrieving data ...