DAYS_BETWEEN formula jira structure

[Alex Agn]

I'm busy creating another structure and since long time I wanted to apply the days-between formula again.
But it seems like I must have forgotten something.

My formula (in formula column): 

IF DAYS_BETWEEN(datepicker,today()<5: 
"Less than 5 days to go!"

I've a case with date picker = 29/01/2024  & today() = 17/12/2023
and there my formula returns "Less than 5 days to go!"  ???

Does anyone see what I missed?

Additionally, I was wondering of Days_between could be combined: 

IF (DAYS_BETWEEN(datepicker,today()<5 ) AND (IF DAYS_BETWEEN(datepicker,today()>0):"Oh no" ?

Kr,
Alexander

[Stepan Kholodov · Accepted solution]

Hello @Alex Agn 

A bracket seems to be missing from the formula and as Hana said above - the days_between function can return a negative value depending on which date comes first(you can switch their places in brackets if needed). If you want to combine both conditions, the formula can look like this:

IF DAYS_BETWEEN(datepicker,today())<5: 
"Less than 5 days to go!" else
IF DAYS_BETWEEN(datepicker,today())<4 AND IF DAYS_BETWEEN(datepicker,today())>0:"Oh no"

I hope this helps. If you need further assistance, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Hana Kučerová]

Hi @Alex Agn ,

please see here

DAYS_BETWEEN returns a negative value if DateTime2 occurs earlier than DateTime1.

Also it should be possible to use logical AND.