Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asmithids
Partner
Partner

Remove Timestamp

Hello,

I am trying to remove the timestamp on a date field.  The date values are formatted as 2017-02-23T00:00:00.

I tried the following functions to remove the timestamp but, they all did not work.

  • Date(Floor(Date),'YYYY-MM-DD) As Date
  • Date(Date#(Left(Date,10),'YYYY-MM-DDT00:00:00'),'YYYY-MM-DD') As Date
  • Date(SubField(Date,' ',1)) As Date

Does anyone have suggestions as to how I can remove the timestamp? 

Thank you in advance for any assistance! 

1 Solution

Accepted Solutions
Tanalex
Creator II
Creator II

FLOOR(<datefield>) AS Date

You can format that field, in the UI, to MM/DD/YYYY.  Or whatever format you need.

View solution in original post

2 Replies
Tanalex
Creator II
Creator II

FLOOR(<datefield>) AS Date

You can format that field, in the UI, to MM/DD/YYYY.  Or whatever format you need.

View solution in original post

asmithids
Partner
Partner
Author

Thank you Michael!