Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can i find out that the existing year is a leap year. or how to calculate 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
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
means instead of variable1 i have to write year field or wat ????????
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
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
Hi,
You can use the same in backend too.
For example.
Data:
Load
if(mod(Variable1,4) = 0 and mod(Variable1,100) <> 0 or mod(Variable1,400) = 0,'Yes','No') as Leap Year
From xyz.
Regards,
Kaushik Solanki