[Ronald McVicar]

This is a reach out to the RDLC experts regarding Datetime data elements.
we have a dataset in NAV that gives us a datetime.  For all our US customers we use  CDATE expression and format as we want.  However for Canadian we are told we need to use letters for month instead of numbers:  JA, FE, MR, AL, MA, JN, JL, AU, SE, OC, NO, DE

so instead of 190613 for June 13, 2018 we are to format 19JN13

Any recommendations and examples? 
The following is what we thought we’d use but instead of numbers for month we have to use letters.

=Format(CDATE(First(Fields!Label_Parameters__Expiry_Date_.Value, “DataSet_Result”)), “yyMMdd”)

——————————
Ronald McVicar, IT Software Mgr
NSP (Quality Meats)
nspproteins.com
——————————

[Suresh Kulla]

Ronald,

You can use MMM to get the month name in three characters. for ex: JAN, FEB… but to get in to your format i recommend you add a custom function and pass the MMM value and return the 2 character.

Something like below and your final expression could like

=Format(CDATE(First(Fields!Label_Parameters__Expiry_Date_.Value, “DataSet_Result”)), “yy”) +  GetMonth(Format(CDATE(First(Fields!Label_Parameters__Expiry_Date_.Value, “DataSet_Result”)), “MMM”)) +
Format(CDATE(First(Fields!Label_Parameters__Expiry_Date_.Value, “DataSet_Result”)), “dd”)

Public Shared Function GetMonth(ByVal MonthName As String) As String    
        Select Case MonthName   
            Case JAN   
                Return “JN”    
            Case FEB  
                Return “FB”   
           
            Case Else    
                Return “”   
        End Select    
    End Function    

——————————
Thanks
Suresh Kulla
NAV Technical Architect
Atlanta GA
——————————
——————————————-

[Ronald McVicar]

Suresh
what a great recommendation. I use this in SQL scripting but not in SSRS (Report Builder: Expression).  I’ll work on it.  This should work.  I believe.

——————————
Ronald McVicar, IT Software Mgr
NSP (Quality Meats)
nspproteins.com
——————————
——————————————-