Script SQL and Master Calendar Date

[Luisanabria]

Hi to everyone

does anyone could help me?  l have this Script from sql server connection

the field PERIODYEAR is in this way:

i have this MasterCalendar

when l load my data, it say that there is a mistake that comes from MAX and MIN, but lm using the correct Field 

l try using this way Date(Fecha,'DD/MM/YYYY')  and Load Correctly but in my table the Year is working wrong:

What could be the problem? is because my field Year is not like date? 

[rwunderlich]

Add the statement:

Exit script;

just before the "Drop Table MinMaxTemp".

Run the script and then examine the contents of the MinMaxTemp table as well as the variables you set with peek. 

-Rob