Blue Sparrows Fantastic Dream

The caster blows a handful of enchanted powder at a creature within range.
On a failed save, the target undergoes hallucinations that bewilder their imagination. The creature undergoes a deep dream state that renders them numb to the real world, effectively leaving them incapacitated for the duration.
As the sell ends, the target feels as though it awakens from the best sleep it has experienced in a long time. The target forgets all details of the day this spell was cast, instead pleasant stories and simple fantasies linger in their mind.

The creature must make a constitution saving throw. On a failure, the target is incapacitated until you lose concentration on this spell. In addition, the creature loses all memory of the day when this spell was cast.
On a successful save, the target is instead stunned until the start of your next turn.

At Higher Levels. If you cast this spell using an 8th level spell slot, the spell lasts for 24 hours. If you use a 9th level spell slot, the spell lasts for a week, and when you lose concentration on this spell, the target stays incapacitated for an additional 1 hour.