Hello everyone.
A very basic question
How do I add a time operator filter that would be work when the time is more than in my Google Sheet? For example: 3:49 PM.
Thank you!
Hello everyone.
A very basic question
How do I add a time operator filter that would be work when the time is more than in my Google Sheet? For example: 3:49 PM.
Thank you!
@Gethino
1.
In programming world, everything has its โdata typeโ.
i.e.)
1 = number type
โabcโ = text type
โ001โ = number type
Output from Gsheet is all text type.
You have to convert date representation
of text into actual date type.
Conclusion:
You have to use parseDate() function
Thank you for the explanation. :slight_smile