Time Off Report | Community
Skip to main content
S
serbannitu123
New Participant
February 6, 2025
Solved

Time Off Report

  • February 6, 2025
  • 1 reply
  • 536 views

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.

Best answer by KellieGardner

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

 

 

1 reply

KellieGardner
KellieGardnerAccepted solution
New Participant
February 12, 2025

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

 

 

    S
    serbannitu123Author
    New Participant
    March 3, 2025

    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
    KellieGardner
    New Participant
    March 3, 2025

    Glad it helped.

    Terms & ConditionsAccessibility statement

    Loading footer...