Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

Get max date and substract 2 days

Hi, how i can get max date? 

 

I chose advanced search and writing this 

=MyDate > Num(Date#(Max(MyDate), 'DD.MM.YYYY')) - 2

and it doesn't work

2 Replies
Taoufiq_Zarra

@Vittore8  can you try :

=Date(Max(MyDate)-2)

SET DateFormat='DD.MM.YYYY';

an example :

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Vittore8
Creator
Creator
Author

=Date(Max(MyDate), 'DD.MM.YYYY') -- I write at least like this in objcet filter(QlikSense), does not work