Hello,
I only have a small problem here: I've a date column (OIDate) in my table (tblSystems). The date has this structure: dd.mm.yyyy.
Now I've another column in this table that should store field values based on the OIDate date with this structure: mm.yyyy.
I'm using an update query to yield the result:
The problem I have: Access tells me that type conversation failures occur. And I don't know why.Code:UPDATE tblSystems SET KalJahr = format(Month(OIDate) & '.' & dateadd('yyyy',abs(month(OIDate)>=10),OIDate),'yyyy');
Could you help me very quick?