I’ve NEVER been good with date calculations. If I have notes with $StartDate and $EndDate values in 2024 vs 2025, how would I write the data query so that I only get notes that fall in 2024?
$StartDate.year >= 2024 & $EndDate.year < 2025
Edit: I have no idea what the format of the data returned by .year is, whether integer, real, or string. The query probably coerces the data to string? @eastgate does it matter if 2024 and 2025 are or are not quoted?
1 Like