Separate date and time stamp

[dastan]

Hi guys,

My data is exactly as mentioned below. And I am trying to separate the date and time on Qlik Sense but unable to do it. Can someone help me. I tried DayName function, also tried Date and Date# but does not gives proper results. The below column has around 1200 line items. Kindly assist. Thank you.

Date/Time Closed

6/13/2023, 4:46 PM

6/14/2023, 9:01 AM

6/14/2023, 9:28 AM

6/13/2023, 3:56 PM

6/21/2023, 9:46 AM

6/22/2023, 10:19 AM

7/6/2023, 9:27 AM

7/6/2023, 5:29 PM

7/7/2023, 10:53 AM

6/16/2023, 1:17 PM

6/15/2023, 3:05 PM

6/15/2023, 1:04 PM

6/20/2023, 12:58 PM

6/15/2023, 3:04 PM

6/16/2023, 2:31 PM

6/16/2023, 1:18 PM

6/22/2023, 11:40 AM

[vinieme12]

as below

Load timestamp(timestamp#(DateTimeClosed,'MM/DD/YYYY, hh:mm TT')) as DateTimeClosed
,Date(floor(timestamp#(DateTimeClosed,'MM/DD/YYYY, hh:mm TT'))) as Date_part
,time(frac(timestamp#(DateTimeClosed,'MM/DD/YYYY, hh:mm TT'))) as time_part

inline [
DateTimeClosed
"6/13/2023, 4:46 PM"
"6/14/2023, 9:01 AM"
"6/14/2023, 9:28 AM"
"6/13/2023, 3:56 PM"
"6/21/2023, 9:46 AM"
"6/22/2023, 10:19 AM"
"7/6/2023, 9:27 AM"
"7/6/2023, 5:29 PM"
"7/7/2023, 10:53 AM"
"6/16/2023, 1:17 PM"
"6/15/2023, 3:05 PM"
"6/15/2023, 1:04 PM"
"6/20/2023, 12:58 PM"
"6/15/2023, 3:04 PM"
"6/16/2023, 2:31 PM"
"6/16/2023, 1:18 PM"
"6/22/2023, 11:40 AM"
];
exit Script;

[pallavi_96]

In order to split the date and time from the same field, you can use the subfield function.
e.g. For Date :- =subfield([Date/Time Closed],',',1)
For Time :- =subfield([Date/Time Closed],',',2)

[dastan]

Its separating date and time  but giving only 1 value per date. For example if 5/4/2023 has 10 line items, above expression is only pulling up 1 value for the date 5/4/2023 and doing the same with other dates.