SID-02067: Date Calc

Status:	Answered	TWiki version:		Perl version:
Category:	SpreadSheetPlugin	Server OS:		Last update:	10 years ago

Hi,

I want to have the following:

How can I realise the format of the first to fields and the calculation of the last field?

-- Christian Schimmel - 2015-05-27

Discussion and Answer

Convert the two dates into serialized dates using $TIME(), then compare them using $ TIMEDIFF().

You seem to use German date format. You first need to convert that into ISO date format or another format $TIME() understands. I recommend splitting up the date into fields using $SPLIT([\.\s], 01.01.2015 06:00), and rearrange the fields using $LISTITEM().

Details at SpreadSheetPlugin.

-- Peter Thoeny - 2015-05-27

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- Peter Thoeny - 2015-12-03

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.