Change value into the field

[pgalvezt]

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.

Thanks!

[MayilVahanan · Accepted solution]

Hi

Try like this,

addmonths(DateField,-1)

or

SetDateYearMonth()

Hope that helps