Custom Value List Search (Month)

[Fraudie]

I have simple database for school which has products and clients and then transactions.

I'm trying to perform a search by month and year. I have the year working fine but i want the pop-up menu for month to come up as the actual month names but then perform the find according to the corresponding month number (e.g. January will search for 1)

Is there a way to have a custom value list which comes up with one thing but searches for another or will i have to make a new bunch of fields in the transaction table?

[Ocean West]

Create a new field:

Month_Number =

Let( [

_month  = "Dec" ;  // or your monthfield

                                

_list = "Jan¶Feb¶Mar¶Apr¶May¶Jun¶Jul¶Aug¶Sep¶Oct¶Nov¶Dec"

] ; 

ValueCount( Middle( _list ; 1 ; Position( _list ; _month ; 1 ; 1 ) + Length( _month ) ) ) 

 )

[Fraudie]

Thanks for your reply.

I fixed it myself after fiddling around for 15mins or so lol

I made a new field in the transactions called month name which was then calculated from one of the date functions, MonthName(Transaction Date) or something.

That made it so it came up with the month name rather than month number. Cheers for the quick reply anyway.