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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Arnaud35
Contributor III
Contributor III

Date

Hi

I have an issue with the formula below :

[Opportunite.Date_de_Commande]={"<=$(=Date('12/2022'),'MM/YYYY')))"}

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel

[Opportunite.Date_de_Commande]={"=Year([Opportunite.Date_de_Commande])<=2022"}

View solution in original post

3 Replies
Arnaud35
Contributor III
Contributor III
Author

i want to use yearend (2022)

thanks for your help

MarcoWedel

[Opportunite.Date_de_Commande]={"=Year([Opportunite.Date_de_Commande])<=2022"}
Arnaud35
Contributor III
Contributor III
Author

Thank you so much for your help !

Is-it possible to avoid specifiing 2022 by using a date function like yearend as current year ?