CODEWITHSUNDEEP
lotus-noteslotus-formula
Paul
Paul

Reputation: 31

lotus notes formula language date range

In one of the databases I work on, it has a field which is a 'Time/Date List or Range'. The values stored are not a list so this can only be a Time/Date range. In fact, looking at one of the values in the document properties, it shows the value to be "25/11/2015 14:00:00 - 25/11/2015 15:00:00". For a list, I would normally extract entries with '@Subset(fieldName; 1)' but this does not work for the daterange type.

Upvotes: 0

Views: 1479

Answers (1)

Paul
Paul

Reputation: 31

Very painful but.

For start date:-

@Date(@TextToTime(@Subset(@Explode(@Text(fieldName);"-");1)))

For start time:-

@Time(@TextToTime(@Subset(@Explode(@Text(fieldName);"-");1)))

For end date:-

@Date(@TextToTime(@Subset(@Explode(@Text(fieldName);"-");-1)))

For end time:-

@Time(@TextToTime(@Subset(@Explode(@Text(fieldName);"-");-1)))

Working now.

Upvotes: 1

Related Questions