As a Knack Builder, I would like to be able to extract single parts from a Date/Time fields so that I can use (and display) those individual components on particular views.
Scenario: Currently this takes many extractions and workarounds to get this to be set up.
If the “from” date value is after today, then Job is “PENDING.”
If the “from” date value is on/before today AND the “to” date value is after today, then Job is “IN PROGRESS.”
If the “to” date value is before today, then Job is “COMPLETE.”
Also: Currently it’s not possible to use the text formula function
formatDate to extract end dates/times and this makes this function difficult to use on all date/time field setups.