Skip to Content
avatar image
Former Member

Format Date

Hi Experts,

I have a Date issue MY date format is 28/02/2017 i need to convert like this "2017-08"

But i was getting like 2017-8 please help me how to get WW format instead of W

Regards,

Vinay G

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 28, 2017 at 09:54 AM

    If you want to display only in the report then you can use this.

    =FormatDate([Date];"yyyy")+"-"+FormatNumber(Week([Date]);"00")

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2017 at 09:56 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2017 at 10:05 AM

    Hi amit,

    Thanks for reply its working

    Thankyou.

    Vinay G

    Add comment
    10|10000 characters needed characters exceeded