You are viewing limited content. For full access, please sign in.

Question

Question

Forms DATEDIF wrong number of input paramters

asked on January 30, 2018 Show version history

The instructions for this function say 3 input parameters but the system wants something different.

 

 

0 0

Replies

replied on January 31, 2018

What are the formats of your two date variables that you are passing as parameters?

Try using the DateValue formula instead of Date

Date is looking for the date as (year, month, day)

DateValue is looking for a date string ("2017-1-14")

=DATEDIF(DATEVALUE(DateA), DATEVALUE(DateB), "D")

1 0
replied on January 31, 2018

Tried switching the date field to use YY-MM-DD and the method to DATEVALUE but it does not let me use DATEVALUE, requires DATE for some reason. I actually get a message that says "something is wrong" when i try to replace date is DATEVALUE.

How do I get a csv date from a date field?

0 0
replied on February 6, 2018

DATEVALUE is looking for a 4 digit year 


It worked for me when I assigned the date fields to be:


 

0 0
replied on February 6, 2018

I applied a Field Rule to only show the calculation field when both date fields were selected because there was an error message on the form until both date fields were selected.

 

Don't know if that helps, but it's a work around!

0 0
replied on January 30, 2018

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.