Query- Selection Criteria

[Former Member]

Hi Experts,

I just created a query with Query Generator that compares purchase details between two date ranges. The dates are provided by the user. On the condition clause, I put T0.Docdate>=[%0] and T0.Docdate<=[%1] for the first range and T0.Docdate>=[%1] and T0.Docdate<=[%1] for the next range. Docdate is the field Posting date and thus on my selction criteria, all the field names appear as Posting Date. I want to change these to be more descriptive like Posting Date 1, 2, 3, 4 or such other description.

How do I do this?

Regards,

Anne

[Former Member · Accepted solution]

hi..

Can you try something like this:

SELECT T0.[DocDate] as PostingDate1 FROM OPOR T0 WHERE T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1]

Thanks