How to calculate the number of days between the dates in two fields

I have two fields in a journal, date1 and date2, which contain dates in the format YYYYMMDD. I want to calculate the number of days between the two dates and put the result it in a third field called days.

Any advice on how to do this would be greatly appreciated.

The raw tiddlywiki method is to use the unix time using the date format TIMESTAMP however there are plugins and support tools see at the bottom of the table at DateFormat see also format Operator

  • Convert a date, do maths, convert back

See Erics tiddlytools for a lot of date time tools and features

1 Like

Thanks @TW_Tones

I looked at Eric’s tiddlytools and have to admit that I was a bit overwhelmed. On first glance the examples at DateFormat look helpful. Let’s see how I get on.

Cheers

@TW_Tones It worked. Thanks for pointing me in the right direction. So often the solutions are already out there but finding them is difficult for a relative newbie like me.