hi,
I'm using the Export to Excel method on a view. When it exports my list to excel, the dates are different from what is stored in my database. Querying direct from my database shows Belgium time (UTC +1).
I checked my server's timezone and it is on Romance Standard Time (UTC +1)
thanks
Best answer by Sunrise
Good day AaronAbe
Please see the following.
“Excel Import Service Broker”: https://community.k2.com/t5/K2-blackpearl/Excel-Import-Service-Broker/ba-p/65814?nobounce,
Export to Excel function in K2: datetime data is not displayed the same as on the SmartForm: https://help.k2.com/support-services/kbt163432.
Best,
Sunrise
Good day AaronAbe
Please see the following.
“Excel Import Service Broker”: https://community.k2.com/t5/K2-blackpearl/Excel-Import-Service-Broker/ba-p/65814?nobounce,
Export to Excel function in K2: datetime data is not displayed the same as on the SmartForm: https://help.k2.com/support-services/kbt163432.
Best,
Sunrise
+7Please see the Resolution section here:
Known Issue: Calculation of historical dates in Daylight Savings Time may be incorrect
Read the last post by Steveh
Hi AaronAbe
Your dates are coming into Excel formatted as Text.
To convert in Excel, click column for date and change the format to Short Date.
Then select Data|Text to columns and click Finish
Regards
Elvis
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
