Current time in object

Anonymous · ‎2018-03-09

Hello,
Is it possible to use current data or time in object? Not only to print it but also to use it in f.e. if - then formula?
Thank you in advance.

Karl Ottenstein · ‎2018-03-09

Yes. The current date/time is returned as a string by REQUEST("DateTime", format_string, date-time-_string).

You can then 'parse' the returned date-time string into numeric values using the SPLIT function - and then use those values for your IF.

Vote for Wish: Copy/Paste in 3D

AC 29 USA and earlier • hardware key • macOS Taho 26.1 MacBook Pro M2 Max 12CPU/30GPU cores, 32GB

Go to post

Karl Ottenstein · ‎2018-03-09

Yes. The current date/time is returned as a string by REQUEST("DateTime", format_string, date-time-_string).

You can then 'parse' the returned date-time string into numeric values using the SPLIT function - and then use those values for your IF.

Vote for Wish: Copy/Paste in 3D

AC 29 USA and earlier • hardware key • macOS Taho 26.1 MacBook Pro M2 Max 12CPU/30GPU cores, 32GB

Anonymous · ‎2018-03-10

Thank you very much.

Current time in object

Didn't find the answer?

Check other topics in this Forum

Read the latest accepted solutions!

Start a new conversation!