This is the case, a timesheet application. I am trying to convert a UTC time to a local time.
I have a form where there is a “Start time”. My Application is standard UTC time.
I have people using it in the Netherlands (Daylight Saving time +2), Netherlands (Central European Time +1), India (India Standard time, UTC+5.5).
If the Start time is not filled in, it should take NOW, but then there must be a conversion to the local time of the user.
I have a set of rules for the different cases to convert it to Local time.
For that I am using the Date Utilities Pipe - Convert Time.
First I set the time to now if the form is saved and the field is still empty.
Then based on the situation I have 2 rules for converting the time:
Rule 3:
Rule 4:
The pipe response is empty, although the rule with the NOW for the start time UTC works.
Is it possible that the problem is that I use a rollup fieldn for the country, which is not available to the pipe, when it is not being saved in the table?
If yes, does someone have another Idea how I can distinguish between countries so the right pipe runs?
Or is there a mistake in the pipe parameters?