Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Display Date as 02-Apt-17

(0) ShareShare
ReportReport
Posted on by 3,027

Hi

  I want to display date as 02-May-17. If date is 02/05/2017 in record.  This is reqd in report.

Thanks

*This post is locked for comments

  • Verified answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Display Date as 02-Apt-17

    Hello use this

    FORMAT("Posting Date",0,'<Day,2>-<Month Text,3>-<Year>')

    Note:

    If Posting date is 05.02.2017 then it reruns like: 02-May-17

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Display Date as 02-Apt-17

    Go to RDLC layout and on textbox properties

    date.png

    Select desire format and check

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Display Date as 02-Apt-17

    FORMAT(TODAY,0,'<Day,2>-<Month Text,3>-<Year>')

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Display Date as 02-Apt-17

    <Day,2><Filler Character, >. <Month Text,3> <Year4>

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Display Date as 02-Apt-17

    Hi

     I want month name 3 character like Apr. Year 2 digits.

    Thanks

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Display Date as 02-Apt-17

    FORMAT(TODAY,0,'<Day,2>-<Month Text>-<Year4>')

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Display Date as 02-Apt-17

    Hi

        Can u pls help how to write in Source Exp. I have written but not working. Format("Posting Date",'did-mmm-YY').

    Thanks.

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Display Date as 02-Apt-17

    hi

    go to your relevant report and follow the instruction given on below link

    msdn.microsoft.com/.../dd301174.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans