Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
With Calendar object it is not possible to select the Date and Time, instead what you can do is Provide to list boxes with Same different fields and use it for selection.
Data:
LOAD
*,
DateTime AS StartDateTime,
DateTime AS EndDateTime
FROM DataSource;
Now use StartDateTime & EndDateTime fields for selection.
Regards,
Jagan.
Use Calendar Object ...
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.
Perhaps this post could help you
Add 2 different calendar objects, one for each date
Hi,
PFA file for solution.
Hope this helps you.
Regards,
Jagan.
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?
Hi,
Did you checked the attached file? It has similar solution.
Regards,
Jagan.
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
];
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