Format Date

[Former Member]

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

[amitrathi239 · Accepted solution]

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

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

[kohesco]

Hi,

check out

https://ibusinessintelligence.wordpress.com/2012/11/02/bo-webi-date-format/

Grtz

Koen

[Former Member]

Hi Koen,

The document was helpful

Thankyou

[Former Member]

Hi amit,

Thanks for reply its working

Thankyou.

Vinay G