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 MyTableSelect MM_FAT,GG_FAT and AA_FAT etc from FATMES9 where...PLEASE HELP ME
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.
David Singleton - MVP Dynamics NAV Dynamics NAV Consultant since 1991 Available for Navision Go-Live assistanceDynamics Book
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,
Harish Mohanbabu Long way to go before I sleep ..