Modify date() criteria

[babinos]

Hello there.
At my clients table i have a birthday context using ONLY day and month. The input mask is __/__ . Now i wanna create a form that running query and searching who have today birthday. "date()" isn't correct cause using __/__/____ as searcher for today. Can someone have any idea how to do ? The others modifies of *date* in criteria does not complete me, as many i know about access, so i thought about "left" criteria within "date()" to not searching year inside context.

PS i dont wanna year at birthday cause the clients are for hairdress store, so too many women for answering that question

Thanks in advance.
Bob

 

[Kryst51]

Look here, I think you need to use the Date Part function.

 

[babinos]

Kryst51,
this faction does not help me cause needs to set a certain day, im looking for a criteria that returns date() without year, thats why i can't helped by others fuctions of date, as i wrote
:-(

 

[Kryst51]

Is your table field set to text? See my attachment and see if it helps you.

 

[Kryst51]

Here's a A2003 version

 

[Kryst51]

Just for closure on this, babinos PMd me, here is what he said:

hey again mate.
i found what is was looking for.
the correct criteria at my query is : format(date(),"dd/mm") !!! and works...
really thanks for your try, i hope this help you at the future

Bob

Which I think is exactly what I was showing him with the attachment I had.