Skip to main content
  • EN

Hello All, Happy Holidays!

I am trying to Extract Records only for the Year (SUBMISSION_YR) (format, '2020') the Tool is Run -

I have WHERE SUBMISSION_YR = YEAR(CURDATE()) but it doesnt appear to be working correctly. This is in the Feature Type>Parameters>Table Settings> Where clause

 

any ideas?

thanks!

 

Hi @curtisd54​ ,

 

Can you try using the following Date Function instead of YEAR(CURDATE()):

@DateTimeFormat(@DateTimeNow(),%Y)

 

Reply


Community Stats

30,161
Posts
114,500
Replies
37,813
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.