Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rushi1093
Contributor
Contributor

date time data filtering

I have to check two date fields for one condition which falls under same day. Second condition considers entries after midnight which still needs to be accounted for that previous date entries. for ex: an entry comes from 12am to 4 am, it should be accounted into previous date only. xyz inquiry coming on 14th july 12am to 4 am should be counted in 13th july. if inquiry come after 14th july 4am, it will be counted in 14th july. 

Labels (1)
1 Reply
vinieme12
Champion III
Champion III

create field as below

, Date(if(Hour(timestampfield)<=4,floor(timestampfield)-1,floor(timestampfield))) as InquiryDate

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.