timedate

[Amyosaka]

Hi, I am totally new to appsheet an I want to make a lunchbox order app for my company.

My question:

one colume named Date/time with valid if: HOUR(timeNow()-"00:00:00")<=9

because I do not want people to order lunch past 9am today, but they can order lunch for the next any day.

It works but from the Date/time dropdown calender they can still choose time before 9am.

Is there a way to show the future time after 9am from dropdown calender?

Thank you for any help!

[TeeSee1 · Accepted solution]

Try this.

if(
 HOUR(TIMENOW() - "00:00:00") <= 9, [_THIS] >= TODAY(),
 [_THIS] > TODAY()
)

Also in the initial value you might want to enter  this for user convenience

if(
 HOUR(TIMENOW() - "00:00:00") <= 9, TODAY(),
 TODAY() + 1
)

[Amyosaka]

Hi TeeSee1, Thank you sooooo much for answering my questions, it seems works fine. I might still have other questions so it would be nice if I can contact you again!

[Amyosaka]

How to choose multiple days from Date/time column drop down menu?