ACL Date Function – Year() Function




A very warm aloha to all my fellow data analysts. I hope we are feeling very proud of each other. After there is a lot to be proud of. We accomplished quite a bit in the past few posts. This series of posts, ‘Audit Command Language Tutorials for Beginners’ has turned out to be quite a trip for our team as well. In our goal to create the simplest approach to impart this knowledge, we have learnt a few new tricks as well ūüôā

In order to keep on improving our approach, let us keep on going with the discussion on the next functions in the series of posts for Audit Command Language, date functions. We have so far covered the Date & CTOD functions. In this post we will be discussing the  Year function. This function is used to extract the year from a date field. This function returns a numeric value.

Syntax: Year(Date)

Example in a script to create a new field using Year Function

DELETE FIELD TEST_Field OK
DEFINE FIELD TEST_Field COMPUTED AS
Year(HireDate)

Example in a workspace to create a new field using Year Function

TEST_Field Computed
Year(HireDate)

See below the result of the Year function.

The Year function is a simple enough function to implement. The point to note however, is that this function provides a numeric value. Check out the video demo below:

Please keep practicing and feel free to reach out to us with your valuable feedback and comments. Please go through the website to review ACL script examples and ACL script commands sign up for our newsletter, so that we may keep you posted on the latest activity on our website and Youtube channel.