Select a range of date-time

[Anonymous]

Hi,

I'd like to select a range of date-time (for example from 01/07/15 10:00 to 08/07/15 08:00).

Does anybody have a better idea than a listbox? It's very hard to use because of the numbers of records inside the range.

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

Thank you so much for the attention.

N.

[alexandros17]

Use Calendar Object ...

[Anonymous]

Right for the Calendar, but I'm not able to select two distinct date/time values and base the database records selection on them.

Could you send a short example, pls?

Thank you.

N.

[sasiparupudi1]

Perhaps this post could help you

how to show the value "from date" to "to date"

[alexandros17]

Add 2 different calendar objects, one for each date

[jagan]

Hi,

PFA file for solution.

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi,

thank you very much for the example. It works fine for the date but, as written above, I need to select two date/time values.

How is it possible in your example?

[jagan]

Hi,

Did you checked the attached file?  It has similar solution.

Regards,

Jagan.

[Anonymous]

Hi,

surely I checked your example, but you don't need to select the hours & the minutes, only the date:

LOAD

Date(Date) AS Date,

Sales

INLINE [

Date, Sales

1/1/2015, 100

1/2/2015, 200

1/3/2015, 200

1/4/2015, 100

];

[sasiparupudi1]

Use the time dimension and populate the time values into an input box using the following post

Need a nicer Drop-down? how about taking advantage of Input Box?

LOAD

Date(Date#(Date,'DD/MM/YYYY hh:mm')) AS Date,

Time(Time#(Date,'DD/MM/YYYY hh:mm'),'hh:mm') as Time,

Sales

INLINE [

Date, Sales

1/1/2015 12:00, 100

1/2/2015 00:01, 200

1/3/2015 23:59, 200

1/4/2015 14:00, 100

];

HTH