Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Re: Flooring mixed timestamp and date data

How about this? Likewise, You need to define

date(Alt(floor([Completed Date]), Date#([Completed Date], 'mm/dd/yyyy hh:mm'),'MM/DD/YYYY') as [Completed Date]

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)