Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • 1. Store dates using a DATE data type 2. (Usually) Don't store data that can be easily calculated on the fly. And shouldn't that be eligibilililility? ;-) Commented Nov 25, 2013 at 11:29
  • Maybe it's just me, but I can't tell how you're determining the value of Eligibilility. In fact, I can't tell what the table represents either. Commented Nov 25, 2013 at 11:38
  • @OGHaza im ll be doing this change every month. so the current month im checking whether this record is eligible or not. Commented Nov 25, 2013 at 11:42
  • Maybe if you add more example data it will be more clear - Ahh, I might understand, if Inserted date is 2013-01-01 and Frequency was Halfyearly, then Eligibility = 1 if current month is Jan 2013, Jul 2013, Jan 2014, Jul 2014 etc.. Commented Nov 25, 2013 at 11:49