creating variable for earliest year

[aheavy95]

Hi all 

I am having a problem creating a new variable in my script.

I am trying to get the earliest sales_date year as a variable to use in the script for storing data by years.

First I loaded the minimal year-  year(min(Sale_Date))  and made sure I got the correct value in the sheet,

and then after going through examples online,  I tried to create the variable using 5 different ways but none of them worked as you can see in a screenshot from the debug:

how should I declare the variable that way I'll get that earliest year?

thanks

Up until now the variable vStartLoad was based of VStartDBAdjustment_Temp and the script worked fine.

Now I was asked to change it to the date I'm getting as the 'Value' - to the start of month of that date

So I created  VStartDBAdjustment_Temp2  and used it in vStartLoad  ,  and when I run the code I'm getting this error at the vStartLoad  declaration.

Does anyone know what am I doing wrong?

thanks

[aheavy95 · Accepted solution]

Solved it by doing:

Peek('field');