Time Off Report

[serbannitu123]

Hello everyone, hope everythings fine!

I am reaching out to you as I am having some troubles exporting the Time Off report to xls as it looks like the dates are automatically adjusted after midnight, therefore it shows as 1 extra day (what should have been in the export 11:59pm Friday turns to 12:00am Saturday).

The report works just fine in Workfront, but as soon as it's exported, it's being adjusted by xls.

showcasing below examples from workfront:

while excel export:

Looking forward to hearing back your thoughts on this. 

Much appreciated.

Serban.

[KellieGardner · Accepted solution]

I'm not sure why it's doing it but if you change the end date to be a value expression with text mode it doesn't change on export.

linkedname=direct
listsort=atDateAsAtDate(endDate)
namekey=endDate
querysort=endDate
valueexpression={endDate}
valueformat=longAtDate
width=100

[serbannitu123]

I havent gotten the chance to thank you, apologise for being late, but yeah that fixed the issue, thank you so much for your suggestion!

[KellieGardner]

Glad it helped.