1
For Date / Datetime fields, the Query Method exposes 3 possibilities: Day, Month and Year.
1. For Date fields, add support for
a. Days - the number of Months, Weeks, Days, Hours, Minutes, Seconds, Milliseconds, Nanoseconds from 0D
b. Duration - length of time between 2 dates in Days, Hours, Minutes, Seconds, Milliseconds, Nanoseconds
2. For Time and Datetime fields, add support for
a. Hour, Hour24, Minute, Second, AmPm
b. Duration - length of time between 2 times in Hours, Minutes, Seconds, Milliseconds, Nanoseconds from 0T
1. For Date fields, add support for
a. Days - the number of Months, Weeks, Days, Hours, Minutes, Seconds, Milliseconds, Nanoseconds from 0D
b. Duration - length of time between 2 dates in Days, Hours, Minutes, Seconds, Milliseconds, Nanoseconds
2. For Time and Datetime fields, add support for
a. Hour, Hour24, Minute, Second, AmPm
b. Duration - length of time between 2 times in Hours, Minutes, Seconds, Milliseconds, Nanoseconds from 0T
STATUS DETAILS
Needs Votes
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team