Select to view content in your preferred language

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

912
2
Jump to solution
08-18-2025 03:31 PM
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
MVP Regular 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
MVP Regular 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