datetime

[Daniel_Bennett]

does anybody know appsheet equivalent to CEILING(D76,"00:15:00")) and Floor(D76,"00:15:00")).

used in a date time context

any help appreciated

[Suvrutt_Gurjar · Accepted solution]

I think you are looking to round off time by higher and lower 15 minutes.

Please take  a look at the tip by @GreenFlux 

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Set-Initial-Value-of-TIME-column-to-nearest-15-m...

Normally , @GreenFlux  should share it as it is his tip. Sharing it since he is not active in the community of late.

@Steve also has some excellent tips on the date time topics. Please take a look at those in Tips and Tricks section.

[Aurelien]

Hi @Daniel_Bennett 

This thread should provide some guidance 🙂

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-Rounding-DateTime-Duration-and-Time-values/m...

You may want to replace ROUND() in this expression with FLOOR and CEILING

https://help.appsheet.com/en/articles/2347637-ceiling

https://help.appsheet.com/en/articles/2357293-floor

[Daniel_Bennett]

Thank you both for your time and effort. Took me a little while to get my head round it but we have success 🙌