Thread: Date format not being copied?

I am using the following code to post an input record to a database but the date format is not being copied to the database? I am using the same code to copy a different record to another database in the same workbook and the date format is being posted correctly!
Thanks in advance

HTML Code: 

Dim NextRw As Long
    With Sheets("CRM")
        NextRw = .Cells(.Rows.Count, 1).End(xlUp).Row + 1
        Range("CRMInputRecord").Copy
        .Cells(NextRw, 1).PasteSpecial Paste:=xlValues, Paste:=xlFormats, Transpose:=True
    End With
    Application.CutCopyMode = False
    Range("CRMinput").ClearContents

hi,
it works fine for me, try to set format-> format cells-> custom dd/mm/yy (or whatever) where you want to paste it.

hi Aland,
thank you for rep! glad it helped you!