Formula based on Leave days

[taylorswiftlover]

Hello, 

I have two fields, Start Date and End Date. I want to create a Formula field that will calculate the number of days between the two dates. Can you help?

 

[SinJunYoung]

Just now, taylorswiftlover said:

Hello, 

I have two fields, Start Date and End Date. I want to create a Formula field that will calculate the number of days between the two dates. Can you help?

 

Hello @taylorswiftlover,

You can use the DateDiff function. Follow the formula here: DateDiff(Day, [@field:Start_Date], [@field:End_Date])

[cheonsa]

Hi @taylorswiftlover,

Here is a reference that you can use for different math functions available in Caspio: https://howto.caspio.com/function-reference/.  

 

 

[taylorswiftlover]

Thanks. But I forgot to mention, I only wanted to calculate where all the leave type is set to 'Vacation'. If the value is something else, I can just place a zero or null or something. Will that work?

 

[SinJunYoung]

Just now, taylorswiftlover said:

Thanks. But I forgot to mention, I only wanted to calculate where all the leave type is set to 'Vacation'. If the value is something else, I can just place a zero or null or something. Will that work?

 

Sure! Just make sure that you have another field for the leave type with text datatype and you can create the formula similar to this:

CASE WHEN [@field:Leave_Type] = 'Vacation' THEN DateDiff(Day, [@field:Start_Date], [@field:End_Date]) ELSE 0 END