date format trunc(sydate)

jasmina_karcic · ‎2022-05-04

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

vinieme12 · ‎2022-05-04

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

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

vinieme12 · ‎2022-05-04

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.