on 06-18-2008 6:37 AM
In my report, i hav to compare the input date with QUATERLY date range. ie. Q1 means 1st APril to 30th june, Q2 means 1st july to 30th Sep, Q3 means 1st Oct to 31st Dec and Q4 means 1st Jan to 31st Mar.
How should i set the values and how to compare my input date with the quaters, how to find the Input dates falls in which quarter?
My input is in the Format MM/YYYY !!
Edited by: Padmashree RamMaghenthar on Jun 18, 2008 7:53 AM
Hi,
Use 4 different ranges and compare them in select query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.