I currently have a dashboard that displays information specific to the user. One of the areas is populated through an API on a daily basis. The information is date specific and the API ‘day’ is UTC time. The problem is that the information pulled changes late in the afternoon or evening giving the information for the wrong day.
Could someone suggest a way to display the information based on the user’s current day not the day as it happens UTC? I tried setting a condition when the API call’s date = current user’s day but the fields are not in the same date type format. I figured it might be a formula for the results of the call to display plus or minus hours based on the user’s timezone.
Any ideas would be appreciated. Thank you!