topic Change value into the field in QlikView https://community.qlik.com/t5/QlikView/Change-value-into-the-field/m-p/428163#M159565 <HTML><HEAD></HEAD><BODY><P>Hello, The client sent me many information in different format. Many of the came with the wrong data. For example the file is called October 2011, however, the column had 02/11/2011. So What I was doing was export the files to txt files and replace the dates (Store table Into Table.txt(txt)) But the 2 last file were too much heavies. How can I do for change directly into the script and change for example 02/11/2012 for 02/10/2012.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 20 Sep 2012 21:01:16 GMT pgalvezt 2012-09-20T21:01:16Z Change value into the field https://community.qlik.com/t5/QlikView/Change-value-into-the-field/m-p/428163#M159565 <HTML><HEAD></HEAD><BODY><P>Hello, The client sent me many information in different format. Many of the came with the wrong data. For example the file is called October 2011, however, the column had 02/11/2011. So What I was doing was export the files to txt files and replace the dates (Store table Into Table.txt(txt)) But the 2 last file were too much heavies. How can I do for change directly into the script and change for example 02/11/2012 for 02/10/2012.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 20 Sep 2012 21:01:16 GMT https://community.qlik.com/t5/QlikView/Change-value-into-the-field/m-p/428163#M159565 pgalvezt 2012-09-20T21:01:16Z Re: Change value into the field https://community.qlik.com/t5/QlikView/Change-value-into-the-field/m-p/428164#M159566 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Try like this,</P><P></P><P> addmonths(DateField,-1)</P><P></P><P>or</P><P></P><P>SetDateYearMonth()</P><P></P><P>Hope that helps</P></BODY></HTML> Thu, 20 Sep 2012 21:08:12 GMT https://community.qlik.com/t5/QlikView/Change-value-into-the-field/m-p/428164#M159566 MayilVahanan 2012-09-20T21:08:12Z