web

You’re offline. This is a read only version of the page.

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.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 467 Super User 2025 Season 2

#2

Martin Dráb 420 Most Valuable Professional

#3

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans