Urgent!insert into and convert field(SQL server to ax)

Finance and Operations/AX Technical Forum
1

Good afternoon,
I’ve a big problem.
In my dbo.FATMES9(SQL Server) I got three fields MM_FAT,GG_FAT and AA_FAT. I want to convert this three fields like this gg/mm/aaaa because the i must do an insert into MyTable in AX.
Someone can help me to do this!
i started to do the query:
Insert into MyTable
Select MM_FAT,GG_FAT and AA_FAT etc from FATMES9 where…

PLEASE HELP ME

2

Hi Andrea,

for Urgent issues, please contact Microsoft and log a PAID support call. This is a volunteer forum, so we can not reply to urgent requests.

3

Hi Andrea,

Assuming the three fields are string, try concatenating them -

GG_FAT + “/” + MM_FAT + “/” …

On another note, I would suggest you to do developer training course.

Regards,