SOLVED!
Current time in object
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2018-03-09 10:27 PM
‎2018-03-09
10:27 PM
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.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
Accepted Solutions
Solution

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2018-03-09 11:12 PM
‎2018-03-09
11:12 PM
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.
You can then 'parse' the returned date-time string into numeric values using the SPLIT function - and then use those values for your IF.
AC 28 USA and earlier • macOS Sequoia 15.4, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
2 REPLIES 2
Solution

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2018-03-09 11:12 PM
‎2018-03-09
11:12 PM
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.
You can then 'parse' the returned date-time string into numeric values using the SPLIT function - and then use those values for your IF.
AC 28 USA and earlier • macOS Sequoia 15.4, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2018-03-10 12:07 AM
‎2018-03-10
12:07 AM
Thank you very much.