I just want to ask, month, day, and year is seperated (see attached file)
The timezone in my computer is in Canada Timezone. However, it needs to be in the China Timezone.
My date is searching for yesterday’s date.
Canada Time = 09/10/2020 (14:28)
Philippine Time = 09/11/2020 (02:28)
Date should search 09/10/2020 because philippine time is in 09/11/2020 (need to get the yesterday’s date)