date formats

[Dolly123]

we have to seperate date and time , time in different columns.

how we can use it ?

[PrashantSangle]

use date() for it

date(fieldName) as date

Time(fieldName) as time

check all options over here

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

Regards,

Prashant Sangle

[Hania · Accepted solution]

Hello @Dolly123 ,

You can try below expression in your script,

Date(Timestamp#(Field-Name,'Date_Time_Formate '),'Date_Formate_Required'),

Time(Timestamp#(Field-Name,'Date_Time_Formate '),'Time_Formate_Required')  

Here I did it on your sample Data as:

After loading your  field, you can create required field using resident load.

load
Date(Timestamp#([lastConvesationTim.e.],'DD-MM-YYYYhh:mm'),'DD/MM/YYYY') as Date,
Time(Timestamp#([lastConvesationTim.e.],'DD-MM-YYYYhh:mm'),'hh:mm') as Time
Resident Table_Name;

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[PrashantSangle · Accepted solution]

It is because you have space between date & Time. like

'01-01-2023 08:11' this is 'DD-MM-YYYY hh:mm' format

change expression accordingly

Regards,

Prashant Sangle