How to separate Date ?

[Brownie]

[MartW]

can you check how this field is stored in the datamodel?

because Qlik stores dates. time and datetime as numeric values. you might see dd-mm-yyyy but Qlik stores the that as 123456 within the datamodel viewer you can check if it states that it is a timestamp or date then you can use the date function in Qlik to convert this to a more readable timestamp

[anat]

load subfield(dt,' ',3)&'-'&subfield(dt,' ',2)&'-'&subfield(dt,' ',6),dt;
load * inline [
dt
Wed Feb 08 08:43:00 UTC 2023

];

[Channa]

try

trim(date(trim(yourdatecolumn))) qlik should identify this as date

[MarcoWedel]

Hi,

one solution might be:

table1:
LOAD *,
     DayName(FollowedOn) as FollowedOnDate,
     Time(Frac(FollowedOn)) as FollowedOnTime;
LOAD Timestamp(Timestamp#(Replace(Mid([Followed On],5),'UTC',''),'MMM DD hh:mm:ss  YYYY'),'MM/DD/YYYY hh:mm:ss') as FollowedOn
Inline [
Followed On
Tue Feb 07 08:43:00 UTC 2023
Wed Feb 08 09:44:00 UTC 2023
Thu Feb 09 10:45:00 UTC 2023
Fri Feb 10 11:46:00 UTC 2023
Sat Feb 11 12:47:00 UTC 2023
Sun Feb 12 13:48:00 UTC 2023
];