Day of birth in lookup

Discuss using and your tips/tricks for CATraxx
Post Reply
Harald
Posts: 7
Joined: Thu Nov 17, 2016 9:07 pm

Day of birth in lookup

Post by Harald » Fri Nov 18, 2016 5:57 pm

Hi,

if I sort in lookup artist/person by born/formed the result is in the form yyyy-mm-dd. I want to display the list in the form mm-dd (the day of birth). Is that possible?

Harald

J.F. Le Deist
Posts: 41
Joined: Thu Aug 20, 2015 7:49 am
Location: Brittany, France
Contact:

Re: Day of birth in lookup

Post by J.F. Le Deist » Fri Nov 18, 2016 9:22 pm

I tried but couldn't too. You can use only "Year" or "Year + Month" or "Year + Month + Day" ( through the "Edit Layout" )

But here is what I could do with Bookcat, it's the same with Catraxx.

I filled the Birth date as usual, but added only the day and month ( without year ) in Custom 6 of Person and called this field Birthday, see ( click on the image to get it bigger ) :

Image

Is it what you wanted ?

Harald
Posts: 7
Joined: Thu Nov 17, 2016 9:07 pm

Re: Day of birth in lookup

Post by Harald » Sat Nov 19, 2016 5:30 pm

Thank you for your reply. Yes that is what I want. Your recommandation could be the solution. But it is much to timeconsuming to add 3500 entries by hand.
I don't know much about sql, but perhaps could be sql the solution?

Harald

J.F. Le Deist
Posts: 41
Joined: Thu Aug 20, 2015 7:49 am
Location: Brittany, France
Contact:

Re: Day of birth in lookup

Post by J.F. Le Deist » Sat Nov 19, 2016 9:16 pm

Harald wrote: I don't know much about sql, but perhaps could be sql the solution?

Harald
I will not help you for this. I'm totally ignorant about informatic languages. I can only fill fields !

Post Reply