Hello PierreThank you, that seems to have been exactly the problem. I didn't know the method DayOfYear translated the date to the number of days, good to keep in mind.Kind regards,Bruno Cotrim

Hello Pierre,Thank you for the suggestion.It is a Date not a Datetime, non the less I've already tried that Kind Regards,Bruno Cotrim

Hello guys,I've a simple query that I've not been able to solve. I'm comparing day of year to day of year to find out someones birthday and it it returning me two days.The query:Note: the @birthday field is a "Date"Result (today 05/14):Sql Query:(Extract(DOY FROM E0.tsBirthdate) = Extract(DOY FROM (...

Hey Jon,Just tried that and it still throws the error out...This is the complete structure of the container:Edit: I also tried removing the container with the linklist unfortunately same thing :/Kind Regards,Bruno Cotirm

Good afternoon guys,I'm having a issue while designing the form that presents the Recipient data.In the Database I've satellite tables that might or not be populated if this recipient has that kind of characteristics, our recipient form is use only as a way to see information about a recipient and I...

I've found a way to do it the way I was expecting to do it.Thank youWodnik​ for unlocking the thought process, my objective was a bit more dynamic than hard coding the number of rows but the input was critical to make me understand it was possible to do it as I had imagined it.The problem was I was ...

Good morning, I've been having a hard time since yesterday because I can't access the data that is in a one to many table in the database.This is the case, I want to send a e-mail to an Employee, using data from one of the month and all the flights of that month.So far I've not been able to find the...