problem with union query with dateadd

[manwe_sulimo]

halo all



i have very simple union query :

SELECT [lastT].[VNid], [[lastT].Expr2, [[lastT].[nextTT]
FROM [[lastT]
UNION ALL
SELECT [[lastT].[VNid], [[lastT].Expr2, [[lastT].[nextTY]
FROM [[lastT]

basically, i have query with ID column and 2 calculated columns that use dateadd function, and i want to create 2 columns query which list all the ID and the dates.

when i try to run the query, i get messege that the data types isn't match (and i have the same data, double check it - both are dates and work on the type of calculataions)

any idea???

[June7]

But you show a 3-column UNION, not 2. Are nextTT and nextTY the calculated date fields? Why don't you give Expr2 a meaningful name?

Post the lastT query.

[manwe_sulimo]

hi
thx for the answer.
i just found out that the original field that used for the "number" data in DateAdd was NULL in some rows, once i set the value to 0 its working.

:-)