First, search the help docs and this forum. Maybe your question has been answered! The debugging steps can help, too. Still stuck? Delete this line and proceed.
What I’m trying to do
I am trying to find a list of notes sorted by an attribute name DateReported in YAML format.
Things I have tried
Search through the forum and tried dateformat method with flatten but result is not what I am looking for.
Dataview code below:
TABLE
Status as "Incident Status",
IncidentTitle as "Incident Title",
SeverityLevel as "SLA",
RCAStatus as "RCA Status",
DateReported as "Date Reported",
DateResolved as "Date Resolved",
DateClosed as "Date Closed",
IncidentConclusion as "Incident Conclusion"
FROM #IncidentManagement
WHERE Status != "Active" AND contains(Project,"iB")
SORT DateReported DESC
Notes with DateReported field is stored in date format like eg. Thursday, 09-Mar-2003 or Thu, 09-Mar-23.