wrong values exported to excel

[ali_hijazi]

Hello
got a table in Qlik in which there are several columns and several expressions
all is good in Qlik
the first 3 column are the Month-Year, From, and To as per below:

some users export this table to Excel however, when the date value is end of month, it is exported as first day of the next month

Kindly advise on how to fix this issue
knowing that the From, and To are dates but numbers, so in the Dimension we put Date(From) and Date(To)

[Clement15]

Hello,

Are your Qlik and your excel on the same UTC?

[ali_hijazi]

I'm opening excel via local desktop app

Qlik sever is in Paris and I'm browsing the app from Beirut- Lebanon 

[Rutvik]

Hello,

Please check what is the date format in Main Section, Is it below ( If not please set)

Also, In UI side use below Date(To) and try.

Thanks,

Rutvik.

[Bhushan_Mahajan · Accepted solution]

@ali_hijazi Try applying floor function first and then Date function to From/To Dates.

[ali_hijazi]

well yes this works 
I just noticed that the To has time as per below:
so I either use Date (floor(To)) or in the script I use Daystart(To)  to reset the time