How a qlikview application created in one timezone will be automatically adjusting with different timezones including daylight saving.
We have below scenario:
We have some orders, if that remains unfulfilled within 24 hours, that should be automatically deleted from the system. I used sysdate to calculate it. But the orders can from any part of the world, so sysdate is not working here.
If you have any idea, then please help me urgently.
Returns a timestamp of the current time from the system clock for a specified time zone. The timezone is specified as a string containing any of the geographical places listed under Time Zone in the Windows Control Panel for Date and Time or as a string in the form 'GMT+hh:mm' or 'UTC+hh:mm'. If no timezone is specified the local time will be returned. If ignoreDST is -1 (true) daylight savings time will be ignored.
