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 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 (GetDate()) AT TIME ZONE 'Europe/Lisbon'))As far as I
understand the problem seems to be in the Time Zone but I can't see how
to solve it...Does any one have a suggestion on how to solve this
issue?Kin...
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'm designing it around that concept,
by hinding the contexts that this recipient does not include, for
example he might or not be part of the loyalty program and will only
have an entry in the loyalty...
Good Morning,I've implemented some workflows to be able to save the text
value of sent SMSs, it works but I've a issue with it that I hope
someone call help me with.To compute the value of the SMS text I'm
building a preview of the event history, using the method
"BuildPreviewFromId", this works for both messages sent via message
center and via regular delivery, the thing is the same method has an
enormous difference in performance when called internally or called via
SOAP Service (for message c...
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 trying to access the DB directly
instead of accessing the Temporary tables and when I tried to access the
temporary tables I had the delivery as "Enable but do not Execute" so
the targetData variable ...
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 data in a test preview as seen in the next
images.The code:The result preview:The data that I've found is the value
of an external key (Unique Flight) in the employeeFlights Table.Is it
possible to a...
