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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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 ?