Min & Max Date

Hi All,

I want to fetch the data between min and max dates as per user input date. some Days i want to include data from additional days. Please suggest me how to implement based on user selection. if i want add few more days how do build it. Any suggestion please.

Thanks In Advance,

Navin

Developer Tools

Input

Dynamic Processing

Join

Accepted answers

Pilsner

@NiranjanK1 Thank you for the clarification. I believe this should be of more help now. When you open it as an app it will now use the max/min values to find a "start" / "end" date which creates the range to filter by. By appending these values to the dataset we can then filter for dates from the dataset within the range of the start/end date.

You may want a select tool after the filter tool to drop some of the fields used for the calculation, it's up to you if you keep them or not.

When you input the max/min values they are taken as the number of days. This can simply be changed if needed to months ect. by going into the formula tool and changing the word "days" to "months".

Does this help?

Screenshot 2023-07-31 121312.png

User input min max dates.yxwz

All comments

Yoshiro_Fujimori

Hi @NiranjanK1 ,

Please give us more information to give you "fastest possible solution".

Posting for Fastest Possible Solution

caltang

Yeah, the only suggestion we have right now is for more information & sample data + expected outputs. Then we can assist you better. Otherwise it's just guessing man lol.

NiranjanK1

@caltang @Yoshiro_Fujimori Please find the sample data we have in flow. If text input value zero we have to pic todays details. If text input value Min-1 and Max +2 i have pic the details yesterday to next two days. How to solve it. please suggest.

Input from users	Min Date	Max Date	Output
	0	0	Todays Details from Data




Input from users	Min Date	Max Date	Output
	1	2	yesterday to next 2days of Data

Book1.xlsx

NiranjanK1

@caltang Any Suggessions please

caltang

From what you are telling me, user input in this case refers to an analytic app.

Correct me if I am wrong - but the user story is something like this:

User selects the dates of their choice.
From the user selection, you get the MIN and MAX dates from the dates selected.
From there, you get Min -1 and Max +2 of the data, and fetch you the Output.

To do this, you'll need an analytic app with an interface. But I have a few questions:

What happens when there are multiple MIN/MAX dates of the same date? Which output will it show?
What does Output even mean in relation to Book1 shared by you?
What is the logic behind Min-1 and Max+2? I am heavily assuming here.

Unfortunately, we still do not have enough information to give you what you want. Can you kindly elaborate more?

Pilsner

I am not certain I have understood your problem correctly however I have created an Analytic App using Numeric up-downs as the input, that presents a table similar to the one you have posted. Let me know how you get on

Min Max Dates output.png

User input min max dates.yxwz

NiranjanK1

@Pilsner thanks for the details, Based on your Output dates, now I need to fetch the data from book1 attached excel. User will give min and max dates range based on his selection we need to populate the data. Thanks in advance

NiranjanK1

@caltang thank you for your details

1. User will give min and max dates

2. Based on his dates range I have to goto the main data to fetch machine information. If 10 dates matching his dates range I have to fetch same data.

3. Minimum date -1 mean Yesterday, max dates 2 means today +2, he will enter in number format 1,2,3

4. If zero means always today's details

5. Not always he will select date range, when ever requirement he will select dates -1 or 2

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335