This topic contains 2 replies, has 0 voices, and was last updated by Kathy Woll 6 years, 8 months ago.

  • Author
    Posts
  • #22552

    Kathy Woll

    Hi

    I have a date field that I need to display only the year (yyyy) in a search result. The field is a custom date field. Can you help with the formula? Thanks
    This is a cached copy. Click here to see the original post.

  • #22553

    rnedelkow

    Something like this should work:

    Code:
    Formula (Text) | TO_CHAR({trandate},'fmYYYY').

  • #22554

    Kathy Woll

    It did, thank you!

You must be logged in to reply to this topic.