Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
its correct.
I want separate date and separate time.
Can you explain with expression ?
Please close this thread by flag correct answer
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')
How to close the flag ?
Qlik Community Tip: Marking Replies as Correct or Helpful
It means mark correct or helpful answer if you get answer ...
Then what is use of timestamp.
Please explain.
with example simple.