Calculating between dates

Calculating between dates

Hi all

New to Zoho Creator but have come from FileMaker/Access style things.

I have an "expiry date" and I would like to show "number of days until".

According to my logic "expiry_date - zoho.createdate".

According to Zoho help it needs to be "(expiry_date - zoho.createdate) * 60 * 60 * 60 / 1000)" [something like that].

But... well the formula syntax is right but the result is weird.

I either get "3" or "-345600000". (depending on the various calculations I am entering!)

So given the "expiry_date" is 01/12/2014 (01st Dec) - what is it I am doing wrong?

Thanks for any help or pointers as to where I can locate the answer.

Regards
Brynley