Date Calculations

[Greg O'Connor]

Greetings.

May I kindly ask somebody to point me into the right direction. I have been trying for hours to get a date calculation right.

The situation is:

a) my FMSA is located at the East Coast - US

my client is in Sydney - Australia

c) the time difference is +20 hours for Sydney

I need a date calculation which sets the date to Sydney time when a new record is created.

Output form must be timestamp. On the server I can use:

Get ( CurrentHostTimeStamp ) which results as: 23.01.2007 19:31:13.

Now I need to add the 20 hours which is: 24.01.2007 15:31:13.

I tried so many different calculations which didn't work correctly.

Another question: Can I subtract TimpStamp fields to calculate "how many minutes since the last record generated"?

Any ideas?

Thanks a lot, Greg

[comment]

1. Try:

Get ( CurrentHostTimeStamp ) + 20 * 3600

2. Yes, you can subtract TimpStamp fields - the result is the difference in seconds. Divide by 60 to get the minutes.

3. What has all this to do with e-mail?

[Greg O'Connor]

Thank you very much. It works very well and you saved me hours of further trying!

Greetings.Greg