<@UDP12QEQL> you can do it by converting both date...
# advancedpdfm
michoel
04/29/2019, 11:58 AM@MikeERPG you can do it by converting both dates to longs.. something like
(.now?long - transaction.duedate?long) * 1000 * 60 * 60 * 24k
karlenigma
05/01/2019, 9:36 AMheya @michoel We have tried this but the email template freemarker doesnt like it at all.
karlenigma
05/01/2019, 9:37 AMAlso the duedate field comes back in the format of 1, May 2019
karlenigma
05/01/2019, 9:37 AMwe dont sem to be able to convert it to a proper datetime
m
michoel
05/02/2019, 12:43 AMI just tried and realized I mixed up my multiply and divide
michoel
05/02/2019, 12:44 AMThis expression is working for me:
${((.now?long - transaction.duedate?long) / (1000 * 60 * 60 * 24))?floor}m
MikeERPG
05/02/2019, 7:42 PMWe just keep getting this error 😞
m
michoel
05/02/2019, 8:47 PMWierd it works for me on an invoice email. Does just
${transaction.duedate?long}k
karlenigma
05/02/2019, 8:48 PMYes that's the one. Now works no problem.
karlenigma
05/02/2019, 8:48 PMI was wondering if it was due to date preferences.
m
michoel
05/02/2019, 8:55 PMMaybe
transaction.duedate?date("<your date format>")?longk
karlenigma
05/02/2019, 8:56 PMI'll try that tomorrow. It's just mighty odd that what you use doesnt work.
m
michoel
05/02/2019, 11:35 PMmessage has been deleted
michoel
05/02/2019, 11:36 PMmessage has been deleted
k
karlenigma
05/03/2019, 9:57 AMThanks @michoel This works when previewing an email but when going to send we get the error above that @MikeERPG mentioned. Don’t see why when previewing it’s fine but then we get the error when trying to send.
m
michoel
05/05/2019, 12:33 AMWow strange, I never tested sending an email. Sound like a defect to me in that case.