Combining two strings into a datetime variable

[Ihsan-Mahdi]

Hello,

I have two string variables in my set that I'm trying to combine into one datetime variable formatted DATETIEM20. I tried different codes and none of them worked. Help please!

refdisdate	refdistime
3/22/2019	17:26
4/25/2019	4:38
7/27/2019	18:31
7/29/2019	15:52
8/21/2019	22:24
10/3/2019	0:13
4/9/2019	10:37
12/20/2019	16:30
8/3/2019	17:45
11/25/2019	17:45

[PaigeMiller · Accepted solution]

UNTESTED CODE

date=input(refdisdate,mmddyy8.);
time=input(refdistime,time.);
datetime_variable = dhms(date),hour(time),min(time),0);

[Ihsan-Mahdi]

Worked like a charm! Thank you 🙂