I need to compare a text column, which contains a string that represent a date in the format dd/mm/yyyy, to a date.
This is the range (let's suppose that is in another sheet that I cannot change, so I cannot format the column to a date, it must remain a string): <https://lh3.googleusercontent.com/-7zcOlwBtv3U/WOt-iTcnTkI/AAAAAAAAAdk/jRBXj1wFPd4c-tuNBZq42inuEXtgKz55wCLcB/s1600/Schermata%2B2017-04-10%2Balle%2B14.39.40.png> I need to compare C to a date, something like this: query(importrange(...); "select A, B WHERE C >= '2017-01-08'") Of course this will not work because only the Aldo row will be shown. Is there any way to convert the column C to a date or format it witt the yyyy-mm-dd pattern? -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/899f8bfa-528d-49c7-a236-11ee454bcc83%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
