Data Fetching problem in excel to tally of Date

Discussion in 'Free Source Codes' started by SUNIL MAURYA, Oct 23, 2019.

    
  1. SUNIL MAURYA

    SUNIL MAURYA New Member


    I have written a code of excel to tally . Which fetch/update data from excel to tally in Ledger master In my Given Aggregate. But the problem is that the Date Field Value is Not Coming.Please Help me in that code.
     

    Attached Files:



  2. rmraja

    rmraja Active Member


    date should be in like : 20190401 in the excel
     


  3. Karthick MS

    Karthick MS New Member


    Use below code to get proper date field
    $$LocaleString:($$StringPart:$_2:8:2) + $$LocaleString:"-" + $$LocaleString:($$StringPart:$_2:5:2) + $$LocaleString:"-" + $$LocaleString:($$StringPart:$_2:0:4)
     


Share This Page