Have separate Date and Time values - How to make a DATE/TIME value

[brendafos]

I have a field for Date and a field for time - but I need a DateTime value so I can do calculations to get Length of Stay resulting in Hours.

How do I do this?

Do I concat the two fields or is there a function for this?

Date example:

[jack_morgan]

Hey there!

There are probably a bunch of different ways to do this but this is a pretty basic concat then reformat. Hope this does what you need!

Jack

[MarqueeCrew · Accepted solution]

Here is an alternative version.

Thanks,

Mark

[brendafos]

MarqueeCrew - Sincere Thanks!

Your example just showed me how to use Formula better.

[MarqueeCrew]

@brendafos you are quite welcome.  While I was completing my module, I saw that @jack_morgan had solved it and stated that there were a bunch of ways to solve it.  I'm glad to have had the opportunity to show you a new technique.  Please feel free to pass it along as your technique in the future.  

[Treyson]

Thank you guys so much for this!