I have a date field in my table named “Date Paid”. I would like to determine the week number of the month that date falls into in another field. Example, 2017-11-01 falls into week one of November, 2017-11-06 falls into week 2. Is there a formula tha...
I have multiple tables in my base. Following is what I’m attempting to do for a formula type field named {Amount Owed}:
IF({I Owe} > 100, {I Owe} / {percent}, {I Owe})
{I Owe} is in the table Med Bills{percent} resides in Med Bills but is a lookup to...
I like to think that would have come to me eventually… But I do appreciate you doing all the thought provoking work for me!
This is my final formula:
VALUE(DATETIME_FORMAT({Date Paid},'w'))-
VALUE(DATETIME_FORMAT(DATETIME_PARSE('01'&DATETIME_FORMAT({...
Thank you for getting me started on this, much appreciated. The function appears to work for MONTH with two digits (i.e. > 10, October) but gives #ERROR! for other MONTH < 10 so I have some playing to do. My date field is also called {Date Paid} so I...
Using
VALUE()
Did the trick, thank you. I don’t see that documented anywhere, either VALUE() or cast, is that in the documentation so I can read more about it?
UPDATE
The field {Amount} is formatted as a decimal but when referenced as a lookup field in another table, it is read as text so math cannot be done on it. Is that by design? If so, how do I get around that?
