cancel
Showing results for 
Search instead for 
Did you mean: 

how to assign default value range? urgent.!

Former Member
0 Kudos

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

View Entire Topic
Former Member
0 Kudos

Hi,

Use 4 different ranges and compare them in select query.