Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i a number of records, each record has a date value in the field "Date".
How can i find the one record that has the first date after today's date or today's date if there is a record that has today's date in the field "Date".
I have tried FirstSortedValue() but this does not seem to give me the right result. It seems to return always the first date within all records - ignoring todays date.
Thanks a lot!
Thanks. This worked.
Hi,
Can you attach some sample datain excel and provide the output that is required.
Deepak
Thanks for your reply, lets take the following sample data:
Event | StartDate |
---|---|
Event_A | 2011-12-23 |
Event_B | 2012-05-10 |
Event_C | 2012-05-16 |
Event_D | 2012-06-02 |
Event_E | 2012-06-15 |
In a text field i want to display: Next event:YYYY-MM-DD
Means: Today it would say: Next event: 2012-05-16...
on e.g. the 22nd of May it should display: Next event 2012-06-02
Hope this illustrates the problem better.
Thanks a lot!
Hi,
Try the attach application.
Deepak
Thanks, but sorry, this is does not work for me.
I need to know for today's date, what is the next event. And i need to display this in a text box. Not sure, how i would do this with your example ...
Hi,
Try this application. You can also you a calendar instead of today to make it dynamic.
Deepak
Thanks. This worked.