Create a personal movie database using Dataview, QuickAdd and Minimal Theme

This script is great and really useful.

I’ve been creating a ‘system’ to track films I want to see, etc using it, but am struggling little with release date:

The script returns a release date in the format: dd MMM yyyy. e.g. 04 Jan 2023.
I’d like to either retrieve this or be able to convert it to the format, e.g. 2023-01-04, in order that using dataview I can create view showing upcoming releases and separately show what films are out now.

I’ve had a bit of a try in dataview to do the conversion but have failed.

Can anyone help either:

  • obtain the release date from IMDB in the format YYYY-MM-DD
  • explain how I might convert DD MMM YYYY to YYYY-MM-DD within dataview so that I can compare it with ‘today’s’ date