Hi! I’m working on a database that tracks kittens placed in foster for a shelter. I know how to use DATETIME_DIFF to get weeks, but am hoping to get weeks and days. Ideally, I would like to have it read XwYd. Can anybody help?
Page 1 / 1
To get the remaining number of days, you need to use DATETIME_DIFF to get the time in days, then use MOD to find the remainder after dividing by 7.
MOD(
DATETIME_DIFF({end date}, {start date}, 'days'),
7
)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.