dategoogle-sheetsgoogle-sheets-formulasubstitutiongoogle-query-language
How to order dates in descending order when there are multiple years in data set
I have an Integromat app pulling weather data with date-time and adding them to my sheet and then I use that data to make some graphs.
The sheet in question can be found here. The weather data is the Data sheet
The issues are in GraphData!A18, GraphData!A31, and GraphData!A130. If I use
=SORT(QUERY(Data!A:D,"order by A desc limit 366"),1,1)
in GraphData!A130, it excludes data from the year 2022 as my date-time is in the format 12.31.2021 01:36. I can't change how Integromat outputs data. I tried to use Format>Number>Custom date and time but it didn't change anything. So, how do I go about changing the formula to also include 2022 data?
Solution
your dates are not valid dates but text strings. to convert them try:
=INDEX(QUERY({Data!A:D, SUBSTITUTE(Data!A:A, ".", "/")*1},
"select Col1,Col2,Col3,Col4 order by Col5 desc", 1))
- How to list all the removable devices with DBus and UDisks2?
- gobject/gnome/glib bindings for D using GIR?
- How do nested functions get compiled?
- The "this" pointer and message receiving in D
- 64-bit executables with DMD
- GtkD with D lang on Fedora
- Why Android used Java concept instead of D language or C or C++? But Chromium web browser is in C++, its very complicated match
- How to use MongoItemWriter to write a List<T>
- Why a function with protected modifier can be overridden and accessible every where?
- Convert Unicode const(uint)* to a dlang character type
- Compiling D with Code::Blocks
- DMD vs. GDC vs. LDC
- Rendering a font in raylib using freetype
- Digital Mars D compiler; acquiring ASM output
- D Programming: openssl rsa forward reference compiler error
- D compiler DMD doesn't link object files
- OPTLINK: Warning 23: No Stack
- Is there a limit in the amount of temporary generated symbols during a project build using dmd 2.063?
- Is this the right way to combine Garbage collected with none Garbage collected code in D
- D compiler (Digital Mars D Compiler) throwing error
- Which D Compiler to Use?
- Splitting a string treating multiple whitespace as one separator
- Proper way of passing array parameters to D functions
- Detailed Valgrind internals documentation
- Is it possible, in D, to tell the garbage collector to not scan a particular pointer (or anything below it)?
- Iterate over key/value pairs in associative array in D.
- Dlang associative array of an array of strings keyed by a string has unexpected behavior
- How to repeat a statement N times (simple loop)
- Is worth the effort to learn D?
- ld: undefined reference to object I can see in objdump