How Do I Extract the Date In a Date/Time Field?

Question

Hi,

I need to combine the Date (month, day, year) from one field with the time from another 24 hour time-stamp field.

Example:

Extract the date from Check In DateTime 8/16/2017 3:11:00 PM and combine it with Arrive-Time 15:11 to show 8/16/2017 15:11.

Thank you for your generous assistance.

Tableau Community Forums Member (Inactive) · Answer

Hi Phillip

I am confused with your data structure.

How two data source look like?

Could you attach two diferent data by csv or excel?

To change the format of "8/16/2017 3:11:00 PM" to " 8/16/2017 15:11" is just date format change which does not require any data combinations.

Hi Phillip I am confused with your data structure.How two data source look like?Could you attach two diferent data by csv or excel?

Thanks,

Shin

Tableau Desktop & Web Authoring