Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have datetime in this format 7/1/2014 0:00. How to retrieve only date from this.
I agree with Marcus, but would add Date() function to show the date
Date(Floor(datetime)) as Date
Date(Floor(TimeStamp#(YourDateTimeField,'D/M/YYYY h:mm'))) as Date
Date(Floor(TimeStamp#(YourDateTimeField,'M/D/YYYY h:mm'))) as Date
or may be this as well:
Date(Date#(SubField(datetime, ' ', 1), 'M/D/YYYY')) as Date
Thanks ALL, I am applying these methods.
This works for me..
Date(num(left(Your_Date_Field,5))) as Your_Date_Field_Name
Give it a try and let me know?
Thanks Everyone for your response.
Great. Mark correct and helpful answer to close the thread.
Mark correct and helpful answer to close the thread.