Date Format

[Corey]

Hello, 

Sorry I am a newbie at this...  I have a table with a date field that looks like this 02/19/2018.   I am using Zapier to move this record to google sheets.  When it gets to Zapier it looks like this 2018-02-19T00:00:00  

The "T" is making it so that google sheets does not recognized this as a date field so I cannot run an operation I am trying to do.  Any suggestions on how I can get the date to not have the "T" in it?  I tried changing the formatting in localizations and it did absolutely nothing.  

Thanks

[Corey]

29 minutes ago, Corey said:

Hello, 

Sorry I am a newbie at this...  I have a table with a date field that looks like this 02/19/2018.   I am using Zapier to move this record to google sheets.  When it gets to Zapier it looks like this 2018-02-19T00:00:00  

The "T" is making it so that google sheets does not recognized this as a date field so I cannot run an operation I am trying to do.  Any suggestions on how I can get the date to not have the "T" in it?  I tried changing the formatting in localizations and it did absolutely nothing.  

Thanks

Never mind... Problem solved.  I changed the date field to a text field and used a calendar pop up and the date now integrates as a proper date.  

[MayMusic]

Thanks for updating us