Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem to choose values between a time period. I want to create a button and when you click on it the time should be between yesterday 06:00 am and today 06:00 am.
The values of yesterday before 06:00 am and today after 06:00 am should not be shown.
Does anyone could give an advice how to solve this problem?
Create a button and in Actions add - select in field (Date field) and add the following condition :
='<='&Timestamp(Today()+(6/24))&'>='&Timestamp((Today()-1)+(6/24))
Attached is a sample data.
The IntervalMatch function might possibly work for you as well, I am not a very good developer, but this one struck me when I read what you were trying to do here:
Hopefully may work or give you some other ideas.
Regards,
Brett