This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
how to script for finding maximum, minimum date value in a row for 100+ columns
Created:
Oct 13, 2020 01:41 PM
| Last Modified: Jun 10, 2023 07:20 PM(2592 views)
i have a table with 500+ rows and 100+ columns. Populated with numeric values (dates). I need to find the maximum and minimum value along each row for earliest and latest date. i guess the script would be similar to 'Maximum (column1........column100)' for each row. But i am not sure how to script the column ranges along each row.