News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Display the TransDate ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Display the TransDate field as MMM-YY format as a column in a View.

(0) Share

Report

Report

Posted on by Prem sai

25

Hi All;

I need to Display the TransDate field of CusTrans Table as MMM-YY format as a column in a View.

For example if Transdate is 07/06/2023 then i need to display as Jun-23 in my View.

Thanks in advance.

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Display the TransDate field as MMM-YY format as a column in a View.

Hi Prem Sai,

You need to use computed column in a view. Adding computed column is little tricky which involves T-SQL.

Refer to the below thread which might help you.

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/394259/view-computed-column-with-formated-date

Thanks,

Girish S.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,137 Super User 2025 Season 1

#2

Martin Dráb 232,879 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans