year

[smilingjohn]

Hi All,

In the script iam using the below syntax to get required output , but when i  reload it is giving me an error ..

can someone please suggest

year(Date)-2  as 2year,

year(Date)-1  as 1year,

Thanks in Advance

[chinnuchinni]

field name should be start with char.

you can rename it as      year2         and      Year1

[Chanty4u · Accepted solution]

or try this

year(Date)-2  as "2year",

year(Date)-1  as "1year",

[suren946]

This works

Temp:

Load

Date,

year(Date)-2  as '2Year',

year(Date)-1  as '1Year'

From xyz.xls

[Chanty4u]

nice   please close the thread by making correct and helpfull answers above.

[Anil_Babu_Samineni]

Curious to know, I am running Reload() without any error

[Chanty4u]

for me its giving error with same code

version 12