shortdog
Active Member
I have searched the forums and haven't found a solution to this.
I have a table that has dates stored as strings. They would have been created based on the users date profile. So while I can use B0500720 to get the system format mask then use B0001390 to get the users format mask in a process run by a user, I haven't been able to find a function or API that would let me pass in a USER ID and it tell me what that users date format is.
I am trying to write a conversion that will take the date in the users format and change it to a JDEDATE. The table has various formats. MM/DD/YY, MM/DD/YYY, YYYY/MM/DD, and YY/MM/DD and also some variations on seperator as well.
Any Ideas?
This is in 9.1 AS/400 but I don't think the solution should be that hard. Seems like someone would have had this kind of requirement before.
I have a table that has dates stored as strings. They would have been created based on the users date profile. So while I can use B0500720 to get the system format mask then use B0001390 to get the users format mask in a process run by a user, I haven't been able to find a function or API that would let me pass in a USER ID and it tell me what that users date format is.
I am trying to write a conversion that will take the date in the users format and change it to a JDEDATE. The table has various formats. MM/DD/YY, MM/DD/YYY, YYYY/MM/DD, and YY/MM/DD and also some variations on seperator as well.
Any Ideas?
This is in 9.1 AS/400 but I don't think the solution should be that hard. Seems like someone would have had this kind of requirement before.