Skip to main content
Question

Extract Records -Year- CURDATE ?

  • December 24, 2020
  • 1 reply
  • 29 views
curtisd54
Contributor
Forum|alt.badge.img+5

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!

 

1 Attachments
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

chrisatsafe
Contributor
Forum|alt.badge.img+2
  • chrisatsafeContributor
  • Contributor
  • January 4, 2021

Hi @curtisd54​ ,

 

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

@DateTimeFormat(@DateTimeNow(),%Y)

 

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.