Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Syed17
Contributor III
Contributor III

Please help me convert this oracle query into qliksense script

Hello All,

trunc(sysdate) between fa.start_date  and nvl(fa.end_date ,trunc(sysdate) + 1)

 

please help me to convert this query into qliksense script and is there any easy way to sort this types query into qlik script.

 

Labels (3)
2 Replies
vinieme12
Champion III
Champion III

as below

 

floor(sysdate) > floor(fa.start_date) and floor(sysdate) < alt(floor(fa.end_date) ,floor(sysdate) + 1)

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

I need to Convert query into Qliksense script Language sir...