Single quotes being added to DATE at the beginning in spreadsheet

[vinodhreddygs]

Hi @theoephraim ,

When Dates are added to the spreadsheet they are preceded with a ' but this should not happen. Is there any way to prevent by adding ' at the beginning of Dates?
Please refer the below screen shot for the reference:

Thanks.

[tsouza]

I got the same issue. Any workaround?

[vinodhreddygs]

I got the same issue. Any workaround?

Still no luck!

[RobertSmith8]

My ugly workaround is to use a helper column like = A1*1

           rawData.getCell(min+j, 4).formula = '=F' + String(min+j+1)+'*1'
           rawData.getCell(min+j, 5).value = moment().format('YYYY-MM-DD HH:mm')

=> Correct date without the ' in column E

[Nemnon]

Correction is very necessary, otherwise you have to be perverted

[Nemnon]

USER_ENTERED or RAW method if RAW, then ' - added

[antony]

It's because you're setting the date as a string. See https://github.com/theoephraim/node-google-spreadsheet/issues/363#issuecomment-1437308370

[theoephraim]

combining into #630