I used text files comma delimited csv ... View more

I use EG. You can dabble with the calculator, go to Advanced Functions and mess around with the functions.    Otherwise, Drag the variable column name into select, then press the calculator thing. and identify the variable from its "source column like 't1'. or something like that and make an input statement.   Also, find out if you can make a case statement.   ... View more

Can you share the syntax error to here? From the little screenshot you shared it looks like you are in the Query Builder, and to me it looks like you did the right thing by applying the DTYEAR format. Perhaps something else needs attention. ... View more