Range values should hold in variable

[jagannalla]

Hi,

- In my sheet i've four inputboxes. First 2 inputboxes are able to choose date and time and when i click the button the applicaton holds data with in the range.

- Now, i want to hold one field value in 3rd inputbox. But the input box not able to hold it, for eg as shown in the below image of 2nd textobject value should hold in 3rd inutbox.

- In button action itself i written for the variable to hold this value.

For your reference i'm attaching my qvw file.

[swuehl]

Hi ravikumar_ajzaas,

I think you need to attach your file?

[#3]

Hi Swuehl,

Please see the attached file

Thanks...

[swuehl]

I see,

You are now getting  the correct Start Lot DateTime and End Lot DateTime, do you?

But you are not getting the correct LotNo.

because you have multiple LotStartDates for some LoNo and

multiple LotNo for some LotStartDates.

Is this possible?

Then we need to use a different approach to get the LotNo.

[#5]

Swuehl,

Yes it is possible?

I am also getting the LotstartdateTimes but not the lots.

Please see the attached file now.

Thanks..

[swuehl · Accepted solution]

I think we cannot use the FieldIndex, FieldValue approach then.

Try attached, I changed the set variable actions like:

=timestamp(Min({<CaptureDateTime={">=$(=vStartDate& ' ' & vStartTime)<=$(=vEndDate & ' ' & vEndTime)"} >} LotStartDateTime),'MM-DD-YYYY hh:mm:ss')

& '('&

concat(aggr(if(LotStartDateTime=Min(total {<CaptureDateTime={">=$(=vStartDate& ' ' & vStartTime)<=$(=vEndDate & ' ' & vEndTime)"} >} LotStartDateTime),LotNo),LotStartDateTime))

&')'

Regards,

Stefan

[#7]

Swuehl,

The expression is working

Thanks for your help.

[swuehl]

That's good news.

Please note that I used the concat only to be prepared for multiple LotNos having the same LotStartDateTime.

In that case, you probably want to add a delimiter to concat function as second parameter, which I forgot in above expression.

Stefan

[swuehl]

Hi Jagan N,

just stumbled over this thread, any success with trying my solution?

[jagannalla]

ya Swuehl.. I got the solution with your help.
Your are realy great.....