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

[sunny_talwar]

May be use Hour() function

Hour(EntryDateTime) as Hour

[Anonymous]

Thx @Sunny TBut i get only round hour if i need also the min ?

E.g 10:25

[Chanty4u]

try

=Hour(Datefield)

[sunny_talwar · Accepted solution]

To get minute you can try this:

Time(Frac(EntryDateTime, 'hh:mm')

Can you check if the selection is now working in your attached sample?

[Anonymous]

Amazing thank you so much !!!

[Anonymous]

How can i make From Hour To Hour Free selection to the user, That will impact the EntryDateTime ?

[sunny_talwar]

Hour to Hour free selection?

[Anonymous]

Yes

[sunny_talwar]

I don't understand what you mean by Hour to Hour selection. Can you may be elaborate?