Date with time

[Anonymous]

Hi All,

Need to know =Date(Time(12/01/2017 4PM),'DD/MM/YYYY hTT');

i got wrong answer.

Please tell me the 4pm result must be show.

Thanks

[Anil_Babu_Samineni]

I am not sure, What are you expecting over here, May be this?

=Date(Date#('12/01/2017 4PM', 'DD/MM/YYYY hTT'),'DD/MM/YYYY htt')

[Anonymous]

its correct.

[Anonymous]

I want separate date and separate time.

Can you explain with expression ?

[Anil_Babu_Samineni]

Please close this thread by flag correct answer

[Anil_Babu_Samineni]

Date

=Date(Date#('12/01/2017 4PM', 'DD/MM/YYYY hTT'),'DD/MM/YYYY')

Time

=Date(Date#('12/01/2017 4PM', 'DD/MM/YYYY hTT'),'htt')

[Anonymous]

How to close the flag ?

[Anil_Babu_Samineni]

Qlik Community Tip: Marking Replies as Correct or Helpful

[prma7799]

It means mark correct or helpful answer if you get answer ...

[Anonymous]

Then what is use of timestamp.

Please explain.

with example simple.