I am using Access 2007. Appending from a Number-- Long Integer data type to a Date data type in Access Query using the following.
PO-AMT-OVRD-DATE: IIf([Field59]>0,Mid([Field59],5,2) & "/" & Right([Field59],2) & "/" & Left([Field59],4),"")
But the problem is that now I have some that are Appending from Text data type to a Date data type in Access Query using the same format but it doesn’t work.
Any suggestions would be appreciated!