Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
jasmina_karcic
Creator III
Creator III

date format trunc(sydate)

Hi experts, 

please for a little help.

I am taking data from sql database (from a view) and i need to write trunc(sysdate)-90. Qlik Sense doesn't understand this format for a date.

How will I change it?

 

Thanks

Jasmina

Labels (1)
2 Replies
vinieme12
Champion III
Champion III

You can use Date#(sysdate,'YourDateFormat')  

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

can you post your script where you are trying this ?

 trunc(sysdate)-90

 

Select statement of your SQL or Load statement?

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