SBX - Search With Button

SBX - Forum Post Title

date as the day of the week

Microsoft Dynamics RMS Forum

hozay asked a question on 8 Aug 2018 12:51 PM
My Badges

Question Status

Suggested Answer

how can i display a date as the day of the week in a report

Reply
TheNeos responded on 15 Aug 2018 2:20 AM
My Badges
Suggested Answer

You can edit any report to show this.

Open the report in Notepad.

Find the column format of the column date that you interested.

Replace Column Format ="" with "ddd, dd-mm-yy"

Save report using UTF-8 and extension ".qrp" not .txt

This will show Date as Tue, 14-08-18

Note that saving with new file name will keep the original report intact.

Reply
hozay responded on 15 Aug 2018 11:07 AM
My Badges

Thank worked Great

Reply
TheNeos responded on 15 Aug 2018 2:20 AM
My Badges
Suggested Answer

You can edit any report to show this.

Open the report in Notepad.

Find the column format of the column date that you interested.

Replace Column Format ="" with "ddd, dd-mm-yy"

Save report using UTF-8 and extension ".qrp" not .txt

This will show Date as Tue, 14-08-18

Note that saving with new file name will keep the original report intact.

Reply

SBX - Two Col Forum

SBX - Migrated JS