Database2

[Yogita_Gaikwad]

how to do sum of amount of same date and set staus reconciled otherwise reconciled

[Gokul_Jayakumar (Gokul Jai)]

@Yogita_Gaikwad
Try this

Datetime.now.AddDays(1).tostring("dd/MM/yyyy")

[Gokul001 (Gokul Balaji)]

Hi @Yogita_Gaikwad

Can you elaborate you query little bit in detail?

If you want to sum the column in excel you can try with the below linq

(From d in dtData.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Sum(Function (x) x)

Regards
Gokul