topic How to assign dynamic datetime field values to a variable in a Macro ? in QlikView https://community.qlik.com/t5/QlikView/How-to-assign-dynamic-datetime-field-values-to-a-variable-in-a/m-p/238228#M89155 <HTML><HEAD></HEAD><BODY><P>I would like to assign a dynamic datetime field values to variables but do not know how to do this (specifically the QV syntax used in the expression) in a macro.</P><P>I have 2 variables, "vFromDate" and "vToDate" and would like to assign the values as below</P><P>vFromDate = <STRONG>timestamp</STRONG>(<B>daystart</B>(<B>min</B>(<B>[Delivery Date (PDT)]</B>)),'M/D/YYYY h:mm:ss TT')</P><P>vToDate = <B>timestamp</B>(<B>dayend</B>(<B>max</B>(<B>[Delivery Date (PDT)]</B>)),'M/D/YYYY h:mm:ss TT')</P><P>I understand that you can set a variable by using the "Set Variable" action. However I would like to find a way to do this inside a macro.</P><P>Any help is appreciated.</P><P></P></BODY></HTML> Fri, 30 Jul 2010 00:34:16 GMT 2010-07-30T00:34:16Z How to assign dynamic datetime field values to a variable in a Macro ? https://community.qlik.com/t5/QlikView/How-to-assign-dynamic-datetime-field-values-to-a-variable-in-a/m-p/238228#M89155 <HTML><HEAD></HEAD><BODY><P>I would like to assign a dynamic datetime field values to variables but do not know how to do this (specifically the QV syntax used in the expression) in a macro.</P><P>I have 2 variables, "vFromDate" and "vToDate" and would like to assign the values as below</P><P>vFromDate = <STRONG>timestamp</STRONG>(<B>daystart</B>(<B>min</B>(<B>[Delivery Date (PDT)]</B>)),'M/D/YYYY h:mm:ss TT')</P><P>vToDate = <B>timestamp</B>(<B>dayend</B>(<B>max</B>(<B>[Delivery Date (PDT)]</B>)),'M/D/YYYY h:mm:ss TT')</P><P>I understand that you can set a variable by using the "Set Variable" action. However I would like to find a way to do this inside a macro.</P><P>Any help is appreciated.</P><P></P></BODY></HTML> Fri, 30 Jul 2010 00:34:16 GMT https://community.qlik.com/t5/QlikView/How-to-assign-dynamic-datetime-field-values-to-a-variable-in-a/m-p/238228#M89155 2010-07-30T00:34:16Z How to assign dynamic datetime field values to a variable in a Macro ? https://community.qlik.com/t5/QlikView/How-to-assign-dynamic-datetime-field-values-to-a-variable-in-a/m-p/238229#M89156 <HTML><HEAD></HEAD><BODY><P>Hey Anthony,</P><P>I'm thinking this should work:</P><P><EM>set v = ActiveDocument.GetVariable("vFromDate")</EM></P><P><EM>v.SetContent activedocument.Evaluate("timestamp(daystart(min([Delivery Date (PDT)])),'M/D/YYYY h:mm:ss TT')"),true</EM></P><P>I haven't tested it out though so you might have to play around with it a bit.</P></BODY></HTML> Fri, 30 Jul 2010 07:02:28 GMT https://community.qlik.com/t5/QlikView/How-to-assign-dynamic-datetime-field-values-to-a-variable-in-a/m-p/238229#M89156 Anonymous 2010-07-30T07:02:28Z