1

I have the following formula and it works fine

=unique(query(ARRAY_CONSTRAIN(ARRAYFORMULA(QUERY(
 {Database!A1:AB, (Database!N1:N)-(Database!M1:M)}, 
 "where Col9 <> '' AND Col1 >= date'2019-05-13'",1)), 999^99, 29) ,
 "Select Col1,Col9,Col29,Col13,Col14,Col21,Col22,Col23,Col24 label Col29 'Horas de Trabajo'",1))

And I have cell C55 that has same data 13 May 2019. But when I refer to this cell in my formula like this:

=unique(query(ARRAY_CONSTRAIN(ARRAYFORMULA(QUERY(
 {Database!A1:AB, (Database!N1:N)-(Database!M1:M)}, 
 "where Col9 <> '' AND Col1 >='"&TEXT(C55,"yyyy-mm-dd")&"'",1)), 999^99, 29) ,
 "Select Col1,Col9,Col29,Col13,Col14,Col21,Col22,Col23,Col24 label Col29 'Horas de Trabajo'",1))

I have an empty query (not an error, but empty). Why?

0

=UNIQUE(QUERY(ARRAY_CONSTRAIN(ARRAYFORMULA(QUERY(
 {TEXT(Database!A1:A, "yyyy-MM-dd"), Database!B1:AB, (Database!N1:N)-(Database!M1:M)}, 
 "where Col9 <> '' 
    and Col1 >= '"&TEXT(A1, "yyyy-MM-dd")&"'", 1)), 999^99, 29),
 "select Col1,Col9,Col29,Col13,Col14,Col21,Col22,Col23,Col24 
  label Col29 'Horas de Trabajo'", 1))

0

  • I see my mistake now. Thanks a lot! – Marchuk Anton May 27 at 16:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.