Error in "Difference" between dates and extracting days of difference

(1) Share

Report

Posted on by DiePic

463

Hi all,

I've this case to retrieve days between 2 dates:

int(split(dateDifference('2023-05-01''2023-05-05'),'.')[0]) - Result of the difference before split 4.00:00:00

after split and int is equal to 4

....

my problem born when the dates are the same:

int(split(dateDifference('2023-05-05''2023-05-05'),'.')[0]) - Result of the difference before split 00:00:00

and the split give me an error because there is no day in the first place, where the divider is the point (.) and not double point (:).
...
Hi need help or any idea to resolve this problem.
Thanx in advance

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @diepic,

You can check if there is a dot in the result with an indexOf function before you split. If it equals -1 there is no dot available and you can simply use 0. In other cases you use your split expression.

Below is an example

if(equals(indexOf(dateDifference('2023-05-05','2023-05-05'), '.'), -1), 0, int(split(dateDifference('2023-05-05','2023-05-05'),'.')[0]))

Was this reply helpful? Yes No
DiePic 463 on at

Like (0)

Report

Hi @Expiscornovus
thank you for your suggestion.
It's working

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @diepic,

Did you copy/paste the code sample I shared or did you change your existing expressions from your opening post?

In case of the latter can you make sure there is a comma character between the two date values? I noticed a typo in the expressions you shared in your opening post. The comma was missing between the two dates '2023-05-05''2023-05-05'.

The format for the date difference should be:

dateDifference('<startDate>', '<endDate>')

Was this reply helpful? Yes No