Date Time

[Anonymous]

Hey Community,

I have field EntryDateTime (15/03/2016 10:40:45)

How can i use only the hour ?

My client wants to chose From - To Hour in his selection

I add the app, the problem is when i choose from the var date From date - To date

And press apply i dont get all the selection

[Anonymous]

Yes sure,

my client wants to see report of his data but also to be able select by Range.

ex. From Data To Date

     From Hour To Hour

     From Price To Price

are you recommend me to do this whit var ?

[sunny_talwar]

Can you reattach the application with these two fields:

1) Date(Floor(DateField)) as New_DateField

2) Time(Frac(DateField)) as New_TimeField

Use the datefield which you want to use for filtering purposes.