how to separate date and time field in qlik sense

[AnkitaC]

Hi All,

please give me solution how to separate date and time field because according to date sales amount is correct but month wise is not match because time and date in same field so how to solve that problem.

date format is like that please give me solution.

yyyy-mm-dd 00:00:00:0

[edwin]

if you just nee dthe date part of a field use date(floor(TIMEFIELD))

[anat]

date(floor(TIMEFIELD)) as date, 

Time(floor(TIMEFIELD)) as time

[AnkitaC]

but after that according to date sales amount means data is match value match but monthly data not match please give me suggestion.

[edwin]

it isnt clear what you mean by monthly data not matching.  maybe post sample data and point to what isnt matching.  you also maybe need to explain what you are trying to do.

[AnkitaC]

actually according to yyyy-mm-dd 00:00:00:0 this format date field column is available in database i have convert it this field into  yyyy-mm-dd  this date and year yyyy and month mm format that 3 fields i convert if i select perticular date in date field then data is match but if i select for example from year field 2022 and from month field jan this data is not match means sales amount not match