find next date

[#1]

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!

[deepakk]

Hi,

Can you attach some sample datain excel  and provide the output that is required.

Deepak

[#3]

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!

[deepakk]

Hi,

Try the attach application.

Deepak

[#5]

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 ...

[deepakk]

Hi,

Try this application. You can also you a calendar instead of today to make it dynamic.

Deepak

[#7 · Accepted solution]

Thanks. This worked.