DATEVALUE() returning all dates with 12:00:00 AM instead of Time RRS feed

  • Question

  • I am concatenating two columns, Date and Time, and wrapping that in a DATEVALUE() func. All columns involved are recognized as Data Type: Date. My problem is the correct Time is not showing up on the output of DateTime -- it is defaulting to 12:00:00 AM. How do I fix my DateTime column? For example row1 should be 1/2/2011 6:48:00 PM.

    DateTime Screenshot


    Thursday, March 17, 2016 4:42 PM


All replies