Selection in three date fields

[#1]

Hi All,

I am facing a problem wherein i have three date fields namely

1. Sales Posting Date

2. Feedback1

3. Feedback2

Now, when i select for eg. 01/04/2014 to 31/03/2015 in Sales Posting Date then i need the same date range to be used for the other two date fields as well, though other values may be possible for that particular selection.

I need to use this as an expression in a text box. Kindly help me on the same.

[ramoncova06]

are you using a master calendar ?

The Master Calendar

I believe in your case you might be able to use a canonical date also

Canonical Date

[petter]

Where are these date fields placed? In three different tables? Or are they all in the same table?

[petter]

If you have all three dates in one table like for instance a Sales table - here is a small demo to show how you could approach your date selection (I have attached the demo App too):

[#5]

Hi...

All these dates are in three different tables.

When we select a date range in Sales table, the corresponding values get highlighted in other tables but what i need is, the data in the other two tables containing feedback dates should be shown for the same date range that is selected.  This i want to do in the front end.

[petter]

So what  are the key fields connecting the tables? Could you give us the details about the various tables involved?