Greater than on a month name

[mentairia]

How do I do a greater than on a text field with a month name in it. Like > november. I want it to equal december how do I get it to do that in a search.

Thanks

Tony D.

[mr_vodka]

I would assume that you have to convert the textual month into its numerical equivalent prior to doing the actual find step. In your script to perform the find, you will need to substitute it with the number first.

[mentairia]

did that with a case calculation but it still did not allow me to sort it by both month and year. I am trying to create a way to change a clients sales agent from a date forward. If I could get it to do do a >= 1 2005 would kick ass but it just says nothing matches this criteria.

[mr_vodka]

You have to still use the day. If you want the whole month, just use the first day.

So, a>= 01/01/05

[mentairia]

NOne of the fields on the billing sheet are a date field. All are text and number fields. SO what can I do without a date field?

[mr_vodka]

Can you post a sample?

You can always use the GetAsDate () function to change the text into Date format for use.

[mentairia]

Does GetAsDate not work with calculated text fields?

[mr_vodka]

another idea is that you can also create another field that stores a converted copy of the original field. in other words, if the orig field has the value november 2, 2005, the other field can convert it to a format like 11/02/05. Then searches can be done in the second field.

You can place the second field behind the first field. Let the second field be enterable in Find mode and the first field no abled.

Just a suggestion.

[LaRetta]

mentairia, you need to be very clear about what you have. Fist you mention month name then sorting on both month and year. So is it one field with month name and another with year? Or is it month number and year number together? Please confirm the specific field type, field name and type of data they contain. If one field is month name, is it validated or do you use a popup so months are entered correctly?

Simply, you need a REAL date field. You will never get an accurate sort on text dates. You asked what you can do without a date field? Squat. You don't need to change your process (necessarily) but without a true date field, it will cause you problems (as it is now). I guarantee it. I suggest that you create a date field that YOU use for accurate finds, sorts and calculations. You may need to leave your existing process in place ... that's okay. We can work around it.

But until we know what you have, throwing out ideas is like throwing a steak to a starving vegetarian. They may be good ideas, but they'll be too hard to swallow. So tell us again what you have ... and we'll be happy to walk you through solving the problem, okay?

LaRetta :wink2: