Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tanjavarwijk
Contributor III
Contributor III

How to convert into 2 fields date and time

8/11/12 11:51:56 AM
8/9/12 11:17:06 AM
8/17/12 12:59:30 PM

I tried timestamp#( ,'DD/MM/YYYY hh:mm:ss')

I tried date#(  ,'DD/MM/YYYY')

1 Reply
rajni_batra
Specialist
Specialist

use date#(8/11/12 11:51:56 AM,'DD/MM/YY')

time#(8/11/12 11:51:56 AM,'hh:mm:ss')