Need date from time stap

[Sra1bandi]

hi team,

i have a date like below

"2019-10-16 13:18:20.000000"

i need it like "16.10.2019" 

i need to this in back end scripting not in front end

Regards,

Sra1.

[RsQK]

Hi, try this:

DATE(FLOOR(TIMESTAMP#(timestamp_field,'YYYY-MM-DD hh:mm:ss.ffffff')),'DD.MM.YYYY') AS date_field

[sidhiq91]

@Sra1bandi  You can try the below script:

NoConcatenate
Temp:
Load DATE(FLOOR(TIMESTAMP#(Timestamp,'YYYY-MM-DD hh:mm:ss.ffffff')),'DD.MM.YYYY') as Date
inline [
Timestamp
2019-10-16 13:18:20.000000
];

Exit Script;

[MarcoWedel]

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