Can I put a Valid_If on DateTime so that user...

[simon_bailey1]

Can I put a Valid_If on DateTime so that users can only choose times with certain minutes?

On this app I need to limit them to 15 minutes, so any times with 00, 15, 30, 45

The reason for this is I’m warning about duplicate jobs for the same person. I’m doing this with a very wide google sheet comparing every 15 minutes of every job. It’s a pain but it works. But if anyone has a better way (if you know what I mean) that would be very welcome. There’s lots of calculations in the sheet, so I reckon it slows down the syncing.

[Aleksi_Alkio]

AND(TRUE,IN(MINUTE([_THIS]-“00:00:00”),LIST(0,15,30,45))) should work.

[jaberz_lim]

simon_bailey1:

Can I put a Valid_If on DateTime so that users can only choose times with certain minutes?

It will works by adding time for the column,
AND(TRUE,IN(MINUTE(TIME([_THIS])-“00:00:00”),LIST(0,15,30,45)))

[simon_bailey1]

@Aleksi_Alkio Thanks That works

[Aleksi_Alkio]

You’re welcome

[Phil]

@simon_bailey1 @Aleksi_Alkio

I added this useful expression to the Data and Time Expression article at help.appsheet.com - Date and Time Expressions

Date and Time Expressions help.appsheet.com

[Aleksi_Alkio]

[simon_bailey1]

Thanks. Some other useful ones on there I might go back to.