Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a list of timestamps and they are all in a listbox.
Now I want the actual/newest timestamp being activated automatically when going into this worksheet.
Is there a possibility to realise this?
Thank you for your help.
Robert
Maxstring(TimestampField).
Check with text box whether you are getting same format as you have for the field..
Yes there is!
Use the OnActivate sheet trigger. You'll presumably need something like Max(YourTimeStamp) as your value.
You could try it with an action with an OnSheetActivate trigger on this timestamp-field with a condition like:
timestamp(max([timestamp-field]))
- Marcus
Hi Robert
you can add a Trigger in the Sheet properties. On Activate Sheet - Select in Field (YourFieldname) - Search String will be =Max(TimestampField)
Tracy
Thank you for helping!
... but this doesn't work.
Is =Max(TimestampField) right?
Maxstring(TimestampField).
Check with text box whether you are getting same format as you have for the field..
You need to ensure that your TimestampField is really a timestamp respectively numeric - if not it need to bechanged within the script with timestam#(TimestampField, 'YourFormatPattern'). Further you need to format the output from the max-function because their return will be a pure numeric number and not have a string-representation.
- Marcus
I would do further checks with various different timestamp-values to ensure that the alpha-numeric return is really always the max. timestamp.
- Marcus