Split date and time from datetime field

Question

How to divide "Date & Time" field into two fields "Date" alone and "Time" alone?

Answer 1

Hi, 

Follow these steps to divide field into multiple fields. 

1. Create calculated field as date by using split function(). here [datetime] is my field name with datetime value.

   

   

You have to convert datetime to string to use split function on the datetime value.

Here index 1 indicates the first word or string before split and so on.

2. Now add these 2 column next to datetime field to see the date and time separately.

Hope this helps you.