How to display time from a date DB field

Need help Database
1

Creating a scheduling app and I have saved available day and time in 2 fields FromDateTime and ToDateTime. I would like to display the time separate from the Date. How do I extract and display the time? I can display just the date with the FormatAs function but the only thing I see for Time is to Extract: Hours and Extract:Minutes. If I use that then I would have to do complicated formatting just to display times correctly. TIA

2

Date:formatted as

3

Thanks so much. I completely missed on the dropdown. Arrrrggg so simple.

1 Like