Date Rang

[#1]

Hi,

I want to create date range that the user can select the data by date ranges

when the user selects the date I want him the select the date in the format:'YYYY/MM/DD hh:mm'

for example, I want to display the data between the dates

2017-07-16 20:00:00  and 2017-07-17 13:00:00

Attached an example

Thanks

[Anil_Babu_Samineni]

What was the logic behind ??

[vishsaggi]

Check Here:

Calendar with time (timestamp)

[#4]

hi,

I want to create in the UI an 'Input box' that will include two variables

1. VstartDate

2. VendDate

in the 'Input Box' I want the user to select a date and  time Range

when the VstartDate will display the start day and the VendDate will display the end date.

the format of the date will be : 'YYYY/MM/DD hh:mm'

how can i create this 'Input box' ?

for example, I want to display the data between the dates

2017-07-16 20:00:00  and 2017-07-17 13:00:00

[techvarun]

Selecting Arbitrary Date Ranges

[#6]

This is not what I was looking for, because I want the user to select date and time range.

[Anil_Babu_Samineni]

I am not sure, To whom you are replying? Any how - Here is the approach where we can

Create 2 variables by help of Timestamp() this will return as you expected rather Date() function

[#8]

hi Anil,

I'm not sure what you mean...

I think the problem is with my MasterCalendar, I think I need to customize it so that it holds time too, using timestamp.

and after so, I need to create the 'Input Box' in the UI  that will hold the date and the time range.

please see the attached qvw.

[Anil_Babu_Samineni]

I don't think why Master calendar, Looks good to me. And nevertheless May be explain in detail with  sample data set. Off course, I've seen the inline data but i am not understand the business because you have only 2 dates. Can you explain what if you have 10 rows with different fields. What are trying now ??

[#10]

this is an example qvw, the real qvw include million of data.

i want the user to select a range of date-time

(for example from 2017-07-16 20:00:00  to 2017-07-17 13:00:00).

It's very hard to use a list box because of the numbers of records inside the range.

I'd prefer an input box for the date-time selection (from and to) and the selection of the records based on them.

I think I have a problem with my MasterCalendar because of the column: SaleDate_DateTimeFormat

It shows the same time on every date

2017/07/16 20:00:00

2017/07/17 20:00:00