End Date - Start Date Calculation

Ask for Help
21

what do you have in else option? did you leave it empty?

22

yes, i make if the end date before today then choose end date
if the end date after today then choose today.
else empty.

23

thatā€™s why is formating as text, put a date there meybe start date

24

Still cannot

image

image
image428Ɨ549 29.5 KB

25

you are missing r in start

26

what r ?

27

why is showing an invalid operation?

28

Thatā€™s my main questionā€¦

30

now date is a date? from the math column

31

yes, correct. when it comes to if then column it cannot detect as date

32

you doing something wrongā€¦ it works for meā€¦

Screen Shot 2021-12-07 at 4.19.25 AM
Screen Shot 2021-12-07 at 4.19.25 AM1188Ɨ1196 102 KB

is probably the way you calculate ā€œNow Dateā€ in the math column, you have empty rows or some other than date format there, thatā€™s why it canā€™t format to date

33

is the results right ?

34

yes, all my apps work on durations

35

this is my now date
both didnt work with +0 or without

image

36

Screen Shot 2021-12-07 at 4.34.28 AM
Screen Shot 2021-12-07 at 4.34.28 AM1412Ɨ1176 131 KB

Screen Shot 2021-12-07 at 4.35.01 AM
Screen Shot 2021-12-07 at 4.35.01 AM968Ɨ1086 89.8 KB

37

you have something on the way that is not formated as DATE, sometimes is hard to find, maybe is coming from relations, or you manually enter or edit some of the dates?
If is not too much work, I will redo all these columns

38

refresh the editor and try to make a fresh sample, with a new columns formatted as a date, fill them up with a date pickerā€¦ and if is still not working, then submit a ticket to glideā€¦