Formula - Date if a condition is true
I am trying to use the formula - Date field to calculate a date that is nine months in the future from a specific date. This part is easy... I've used AdjustMonth([Date Due], 9). But I only want a ...
Forum Discussion
Yep,
A date field type is a date field type and a text field type is a text field type even if it calculates to some words that happen to look like a crazy formatted date with background text coloring.
So, you can't add 30 days to random "blah blah blah" words. "blah blah blah" plus 30 days is not something that makes sense.
A date field type is a date field type and a text field type is a text field type even if it calculates to some words that happen to look like a crazy formatted date with background text coloring.
So, you can't add 30 days to random "blah blah blah" words. "blah blah blah" plus 30 days is not something that makes sense.