Categories
Dynamics NAV HOW TO Microsoft VB.NET Visual Studio

HOW TO calculate the weekday name in RDLC

To calculate the weekday name in RDLC you can use a combination of two Visual Basic functions:

  1. DatePart
    Syntax

    DatePart(interval,date[,firstdayofweek[,firstweekofyear]])
    

    firstdayofweek is an Optional parameter and the Default value is 1 (Sunday).
    firstweekofyear is an Optional parameter and the Default value is 1 (January).

  2. WeekdayName
    Syntax

    WeekdayName(weekday[,abbreviate[,firstdayofweek]])
    

    abbreviate is an Optional parameter. A Boolean value that indicates if the weekday name is to be abbreviated.
    firstdayofweek is an Optional parameter and the Default value is 1 (Sunday).

  3. HOW TO calculate the weekday name in RDLC

    CORRECT RESULTS
    [sourcecode language=”VB”]
    =WeekDayName(DatePart("w", Fields!CurrentDate_System.value,0))
    =WeekDayName(DatePart("w", Fields!CurrentDate_System.value,0,0))
    [/sourcecode]

    WRONG RESULTS
    [sourcecode language=”VB”]
    =WeekdayName(DatePart("w", Fields!CurrentDate_System.Value))
    =WeekdayName(DatePart("w", Fields!CurrentDate_System.Value),false,0)
    [/sourcecode]

    Did my HOW TO help you? Leave a reply.