Select to view content in your preferred language

Datetime Calculation error - Type Mismatch - Converting out of range value \ Invalid

528
2
Jump to solution
3 weeks ago
MaazaMekuria
Frequent Contributor

I am not sure what is causing this error on date calculation but it is limiting me to only 24 days of difference between a start date and a future date. Changing the value of the variable from 30 to 24 and below will not cause error but anything above causes an error as image pasted below .  I have not experienced this before and I check the date value produced by the calculation and it appears to be perfectly valid for the Unix Date computation using Python TimeStamp functions.  Is there a limitation  on the function used in XLS forms for the amount of future date calculations?  Again it does not follow any logic here and I am not sure if  a parameter is missing etc.  

The sample spreadsheet is attached for your review.  I am using the latest connect executables.

MaazaMekuria_0-1755556188254.png

 

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
Neal_t_k
Frequent Contributor

Try this out, for some reason it didn't like the unix epoch date calculation, but decimal date is working

View solution in original post

2 Replies
Neal_t_k
Frequent Contributor

Try this out, for some reason it didn't like the unix epoch date calculation, but decimal date is working

MaazaMekuria
Frequent Contributor

Thank you, Neal.  That is a neat workaround the problem.  This must be a bug that causes the error in the epoch calculation. 

0 Kudos