Good morning friends, I am inexperienced in the world of AX and I have a problem here, I created a Job to import a register of a file. txt, here everything certain, but my date field is with the inverted format, when it is converted of anytype for date: Example: Field of the date of the file. txt after having converted inside of the variable type dates 22/07/09 9/7/2022 Format: D/M/Y
conversion method: VarDate = any2date(conpeek(curretLine,#Date)) ;
in the moment that is converted by the function, any2date she acquires the date in the format Y/M/D, (but the date that this in the format D/M/Y in the. txt) and later in my database he assumes the format D/M/Y, creating this this inversion of the position of the value of D with Y.
I would like to know if a method exists to convert the anytype maintaining the format D/M/Y ???
Hello Alan, I believe you are looking for something like this
static void Job1(Args _args)
str myDate = "22/07/09";
myConvertedDate = str2DateDMY(myDate);
why don't you try get the date on a string variable then convert it to date
This post is from the year 2009. I think Alan already knows how to achieve this?
André Arnaud de Calavon | Microsoft Dynamics AX Solution architect | My blog | My company
This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.