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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

date fonctions

Hello Guys,

Hope all is all

Could anyone explain to me the fonctions to_date/ to_char/to_months ?? and why they are used together in the expression bellow

date>= to_date(to_char(add_months(SYSDATE,-6),'DD/MM/YYYY'),'DD/MM/YYYY')

Thank you so much

1 Reply
its_anandrjs
Champion III
Champion III

Dear

It is a SQL related question better you can discussed this on SQL community.

Regards

Anand