example - scorpio starts on 23rd oct and ends on 21st nov. My db has fields for start month = 10, start date = 23, end month = 11, end date = 21 for scorpio.
so if a person enters his date of birth as 31st oct YYYY, my query should check the date 10/31 against my db using the logic above , which is if the start month field matches 10 then check date >=23 . Now the second constraint which I have pud for second search is if the month is 11 .. I am unable to combine these 2 using “Merged with”. I have tried using single constriant but unable to do so since I dont have “or” or “and” to select in the option.
My final search line is - (Search for Zodiac Signs (Start Boundary) :merged with Search for Zodiac Signs (End Boundary)) :first item
and the Queries for start boundary and end boudary is as below:
Query 1 (Start Boundary Check)
- Condition: If the Start Month of Zodiac Sign = DOB’s Month
- AND Start Day ≤ DOB’s Day
Query 2 (End Boundary Check)
- Condition: If the End Month of Zodiac Sign = DOB’s Month
- AND End Day ≥ DOB’s Day
Forum
Academy
Marketplace
Showcase
Pricing
Features