Hi,
i’m trying to retrieve date difference from issued date to current date in Sage but somehow I must have my formula wrong, need some help.
I’m hoping someone can let me know what I’m doing wrong.
PrmChg.chgdte is the date field from Prime Change Order I’m trying to calculate the date from.
(DATEDIFF(dd, PrmChg.chgdte, CURDATE())+1)
Thank you.
Correct. For it to work, the field used needs to be either Date or DateTime type.
If your date is in a string field, you'll have to convert it to a date value (handling non-date string values manually…
Hi Josue Garcia ,
You may want to post your question in the Sage 100 Contractor forum here. I'm happy to move this post as well.
Warm Regards,
Erzsi
Why not just use a CR formula?
Correct. For it to work, the field used needs to be either Date or DateTime type.
If your date is in a string field, you'll have to convert it to a date value (handling non-date string values manually) before it will work.
See highlighte in yellow what I get from this formula.
Use a Formula Field instead.
Thank you for your time but I can't find the fomrula field. when i'm in the report writer, I only get calculated fileds.
