How to check between 2 dates?

Still-learning · January 27, 2023, 4:38pm

I dont know hindi… Ok, in your gsheet just create one more colum at the end of your all colum like this… this col will convert all dates into numbers

and in app create one procedure there by inital and final date are converted into numbers… by using this number ony we are going to filter values…

Ok? understand?

let me show the app side

and in app just set this as url

https://docs.google.com/spreadsheets/d/{your_Sheet_ID}/gviz/tq?tqx=out:csv&sheet={Sheet_Name}&tq=Select A,B,C where E >= getglobalstart_date and E<= get global end_Date

this event can be triggered by a click or like this

thats all foks… your data is ready to come from gsheet after filtering
@Alisson_Silva

Understand???

Alisson_Silva · January 27, 2023, 5:09pm

nothing yet

has no result

@Still-learning

Still-learning · January 27, 2023, 5:11pm

check this aia… i have added such thing and works well… also no need of multiple global variables… Only one alone is enough

(unable to upload the aia here, let me share my gdrive link)

wait…

Updated @Alisson_Silva

Test it and let me know

Alisson_Silva · January 27, 2023, 5:38pm

OK friend

almost everything right
on the second date
I put it on the day in the table
but don’t show up
I add another 2 to 3 days and then he’s on the list

06 - 01/10/2023

return only from the 07th

@Still-learning

Still-learning · January 27, 2023, 6:04pm

TM i will check it

Alisson_Silva · January 27, 2023, 7:06pm

friend

I think some error in date format for kodular value
it counts -3 on dates
how is it possible?

@Still-learning

Taifun · January 28, 2023, 5:05am

What about providing some relevant blocks, the result you expect and the result you get instead?

Taifun

Still-learning · January 28, 2023, 6:50am

just try this method… change the date format into yyyy-MM-dd and try this aia

no issue… working fine

sample url to tst it… just change the date in the url and hit

Sheet1

https://docs.google.com/spreadsheets/d/12qwBiC6wQTxtMO3OZ9mj7A6YSldjnTgvySIpJv-1hyg/gviz/tq?tqx=out:html&sheet=Sheet1&tq=Select A,B,C where C>=date ‘2023-01-07’ and C<=date ‘2023-01-10’

Controle_Palito_Doce_beta(1).aia (2.3 MB)

after changing the date format test the aia… delete the datevalue colum

Still-learning · January 28, 2023, 1:44pm

pls make a changes here inorder to work. Just now tested and corrected these to get exactly the filtered values
Do not give any extra space, it will not work… earlier i encountered with problem due to one extra space and it takes lot of time to recognise it…

@Alisson_Silva

Alisson_Silva · January 28, 2023, 1:53pm

denied my friend

no results

@Still-learning

Still-learning · January 28, 2023, 1:54pm

i am testing in your aia only i am seeing the results exatly

See the response

Alisson_Silva · January 28, 2023, 2:12pm

friend, you asked to remove the spaces
oh it didn’t work
when I put it on it worked

let’s continue with the project

thanks

@Still-learning

Alisson_Silva · January 28, 2023, 2:27pm

https://docs.google.com/spreadsheets/d/1IQK0DWIiTuxFhoRtwQgC20tXXKHHqgvnZwnRGSfL11Q/gviz/tq?tqx=out:html&gid=0&tq=Select B,A,Sum(F) Where H>=date’2023-01-07’and H<=date’2023-01-10’group by B,A

friend in this command line

how could add only items selected by date

@Still-learning

Still-learning · January 28, 2023, 3:01pm

you are going deeper into deeper… First celare yoruself with waht you want…

Do You want data between two dates or data for selected dates? also you are continuing inanother one topic… pls more precise what you want… do not make me to spend time with your project by tagging multiple times…

Alisson_Silva · January 28, 2023, 3:12pm

OK friend

I’ll open a topic about it

data for selected dates

Thank you for your help

Still-learning · January 28, 2023, 6:06pm

i dont think you can call at a same time this query, based on lopp method only you have to call upon one by one on selected dates… there is no query option to call up on multiple dates … call by specific date or range of date only avaliable

Alisson_Silva · January 29, 2023, 1:11am

friend how do i get back the date dd-MM-yyyy
in the list view

she is yyyy-MM-dd

I already made several changes and nothing
@Still-learning

Alisson_Silva · February 3, 2023, 11:44am

Good Morning
Friend

How do I add hours from sheets

can you help me

@Still-learning

Still-learning · February 3, 2023, 3:02pm

Yes but still more i need explanation

Alisson_Silva · February 3, 2023, 7:03pm

OK
let’s go
I have a sheet in column A 1234A
Column B 06:54:41
Column C 05:15:12
Select Column A with 1234A and sum the hours of the other columns related to Column A.