the personal blog of adam spriggs
Here’s an AMPscript snippet to determine if a date falls in the Daylight Savings period as defined by NIST.gov:
Output:
dateToCheck: 2023-10-25
month: 10
day: 25
dayOfWeekToFind: Wed
dayOfWeekNum: 4
prevSunday:
isDST: 1
Try it yourself with multiple dates: https://mcsnippets.herokuapp.com/s/6tGSENDB
NOTE: this doesn’t handle times, but could be expanded to do so.
Guy: If you could go anywhere in the world, where would you go?
Kid: I would go that way.
Guy: Why?
Kid: A hot dog that way.
Guy: Let me rephrase the actually rephrase the first question. So if you could go anywhere at all in the world, where would you go?
Kid: That way.
Guy: Would you rather go to Paris, France, or that way?
Kid: That way. I can get hot dogs, gummy bears, sausages and meatballs and donuts — like all the things I can get there.
Guy: What do you want to say to the people at home who are, like, I don’t know if I should go that way.
Kid: Guys, you have to go that way. See, those guys are running that way and those people are going that way. We don’t like those people.
Is generative AI technology the true danger or is it the gamification of mass data collection?
The Little Shop of Horrors is a horror comedy musical about a nerdy florist named Seymour Krelborn who discovers a strange and unusual plant. The plant, which he names Audrey Jr. after his co-worker and love interest, Audrey Fulquard, has an insatiable appetite for human blood. At first, Seymour is reluctant to feed Audrey Jr. human blood, but he eventually gives in when he realizes that the plant is making the flower shop a success. Audrey Jr. grows rapidly and becomes a local celebrity, attracting customers and media attention. Seymour’s newfound success comes at a price, however. Audrey Jr. demands more and more blood, and Seymour is forced to kill people in order to feed the plant. He also begins to lose control of Audrey Jr., which becomes increasingly aggressive and dangerous. In the end, Seymour is forced to confront Audrey Jr. and destroy it. He saves Audrey from the plant, but he is ultimately consumed by it himself.
(synopsis via Bard, because why not?)
This comes up a lot — trouble joining the _Journey and _JourneyActivity data views. The issue is that the VersionID is a UniqueIdentifier data type behind the scenes. The workaround is to cast/convert it to a varchar(36):
I like to maintain a list of Journey _Job records beyond the 6 month lookback threshold for the data views. You can apply the same VersionID join trick on this one also: