Date conversion giving null values

[hf14]

I have date field as string type:

Date
20240304

I want the output date as:

Mar 04, 2024

I tried datetimeparse tool nd used custom format to : MMM dd, yyyy 

But this is giving null values 

[binuacs]

@hf14