topic Victoria Day - How to date calulate in App Development https://community.qlik.com/t5/App-Development/Victoria-Day-How-to-date-calulate/m-p/1340922#M29586 <HTML><HEAD></HEAD><BODY><P>I am creating a master calendar with holidays and am looking at how to determine the date for the following:</P><P></P><P><STRONG>Victoria day is the Last Monday preceding May 25.</STRONG></P><P></P><P>I am trying to determine this in a LOAD statement. </P><P></P><P>I can already do fixed dates shifting to a weekday from a weekend and floating dates such as 3rd Monday in June etc, but this one is stumping me. </P></BODY></HTML> Thu, 25 May 2017 23:06:55 GMT 2017-05-25T23:06:55Z Victoria Day - How to date calulate https://community.qlik.com/t5/App-Development/Victoria-Day-How-to-date-calulate/m-p/1340922#M29586 <HTML><HEAD></HEAD><BODY><P>I am creating a master calendar with holidays and am looking at how to determine the date for the following:</P><P></P><P><STRONG>Victoria day is the Last Monday preceding May 25.</STRONG></P><P></P><P>I am trying to determine this in a LOAD statement. </P><P></P><P>I can already do fixed dates shifting to a weekday from a weekend and floating dates such as 3rd Monday in June etc, but this one is stumping me. </P></BODY></HTML> Thu, 25 May 2017 23:06:55 GMT https://community.qlik.com/t5/App-Development/Victoria-Day-How-to-date-calulate/m-p/1340922#M29586 2017-05-25T23:06:55Z