topic Re: If Statement in Macro Help in QlikView https://community.qlik.com/t5/QlikView/If-Statement-in-Macro-Help/m-p/908927#M983480 <HTML><HEAD></HEAD><BODY><P>Next time please post your code as text.</P><P></P><P>you have a quote in the parentheses that isn't closed.</P></BODY></HTML> Tue, 04 Aug 2015 12:05:39 GMT m_woolf 2015-08-04T12:05:39Z If Statement in Macro Help https://community.qlik.com/t5/QlikView/If-Statement-in-Macro-Help/m-p/908926#M983479 <HTML><HEAD></HEAD><BODY><P>I am currently trying to add an if statement into some code in a macro design to send automated emails every day.&nbsp; Currently the macros runs great except now I am being asked to have the emailed data go out for the previous month if the day of the month is less than or equal to 5.&nbsp; Our company has a roll over date of 3 business days to get all data in for the prior month before closing the books. With the weekend this is where the 5 days works out perfectly.&nbsp; My code in the macro is shown below.&nbsp; I believe all variable are self explanatory but if not let me know and I can clarify.&nbsp; When I type this code in the macro and hit ok I get an error message that is shown below.</P></BODY></HTML> Tue, 04 Aug 2015 05:04:57 GMT https://community.qlik.com/t5/QlikView/If-Statement-in-Macro-Help/m-p/908926#M983479 2015-08-04T05:04:57Z Re: If Statement in Macro Help https://community.qlik.com/t5/QlikView/If-Statement-in-Macro-Help/m-p/908927#M983480 <HTML><HEAD></HEAD><BODY><P>Next time please post your code as text.</P><P></P><P>you have a quote in the parentheses that isn't closed.</P></BODY></HTML> Tue, 04 Aug 2015 12:05:39 GMT https://community.qlik.com/t5/QlikView/If-Statement-in-Macro-Help/m-p/908927#M983480 m_woolf 2015-08-04T12:05:39Z