CODEWITHSUNDEEP
archerrsa-archer-grc
KatC
KatC

Reputation: 3

RSA Archer - Calculated field based on date field

RSA Archer - I would like to create a calculated field based on a date field that is in the format dd/mm/yy. The calculated field needs to show both the Quarter and Year of the date field. Is this possible?

I have tried using Quarter([date field]) and YEAR([Date field]) - is there a way to combine both to get an answer ie 1 2016

Upvotes: 0

Views: 1400

Answers (1)

Tanveer Shaikh
Tanveer Shaikh

Reputation: 1688

QUARTER([Date Field]) &" "& YEAR([Date Field])

OR

CONCATENATE(QUARTER([Date Field])," ",YEAR([Date Field]))

This will give you the result in the format you need.

Hope this helps!

Upvotes: 1

Related Questions