Lookup functionality

Hi All,

I have written a lookup method on string field which gives the lookup of all the entered date of the same form, but instead of date I have to show the months on lookup. How can I achieve the same?? I need it for searching purpose in the form.

Let me explain my issue through example:

ID (lookup) …………………….
Search Button
Month (lookup) …………………

ID

Date

Price

1

01.Feb.13

2

2

02.Mar.13

3

Month lookup should contain Feb and March instead of the date.

HI,

You can use sub string i.e., substr. using this you can archive this easily.

Hope this will help you.

you can better use intvName-function. in this example i used today(().

intvName(today(), 3, intvScale::Month)

Hi Andrea,

How can I use the same in lookup method?

Please revert.

Thanks. :slight_smile:

Hi Sravya.

Can u please tell me how can I use it in lookup method? Please provide me an example. Thanks. :slight_smile:

i dont have AX on hand. but in this page you will find some examples:

http://www.schweda.net/blog_ax.php?bid=420