Change Date Format In Item Monthly Summary Report

Discussion in 'Requests' started by HAROON2015, Sep 19, 2019.

    
  1. HAROON2015

    HAROON2015 Member


    hi,
    i want to change date format in item monthly summary report
    19-Sep to 19-9

    hope some will help
    thaks
     


  2. teja varma

    teja varma Active Member


    this i will change the default format for day breakup
    Code:
    [#System: Formula]
         DayFormat    : $$String:$DayOfFromDate + "-" +$$String:@@Monthnumber
            Monthnumber :if $ShortPeriodDateFrom  = "Jan" then 1 else if $ShortPeriodDateFrom = "feb" then 2 else if $ShortPeriodDateFrom = "Mar" then 3 +
                           else if $ShortPeriodDateFrom ="Apr" then 4 else if $ShortPeriodDateFrom = "May" then 5 else if $ShortPeriodDateFrom = "Jun" then 6 +
                                                                        else if $ShortPeriodDateFrom = "Jul" then 7 else if $ShortPeriodDateFrom = "Aug" then 8 +
                                                                        else if $ShortPeriodDateFrom = "Sep" then 9 else if $ShortPeriodDateFrom = "Oct" then 10 else if $ShortPeriodDateFrom = "Nov" then 11 +
                                                                        else if $ShortPeriodDateFrom = "Dec" then 12 else 0
        
     
    HAROON2015 likes this.


  3. mukeshb

    mukeshb Member


    Dear Experts,

    How can we add Year After Months in Monthly Summery,
    Kindly help.

    upload_2019-9-20_13-35-39.png


    Thanks,

    Mukesh B.
     


  4. HAROON2015

    HAROON2015 Member


    Code:
    [#Line: DSP accline]
    add: left field: at end : yeardisplaya
    local:field:yeardisplaya:set:$$number:$$YearOfDate:$$perioddatefrom
    
    [field:yeardisplaya]
    use : simple prompt
    color : Blue
    skip : yes
    
    try this
     
    Last edited: Sep 20, 2019
    mukeshb and SHAHCOAL PVTLTD like this.


  5. HAROON2015

    HAROON2015 Member


    thank you teja verma

    best regards
    mohd haroon
     


  6. SHAHCOAL PVTLTD

    SHAHCOAL PVTLTD New Member




    THANKS A LOT (it looks cool)
     


  7. mukeshb

    mukeshb Member


    Thank You Very Much Sir.
     


Share This Page