Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
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 ???
why don't you try get the date on a string variable then convert it to date
Hello Alan, I believe you are looking for something like this
static void Job1(Args _args)
str myDate = "22/07/09";
myConvertedDate = str2DateDMY(myDate);
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.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics