Skip to main content
A
akshayg0006
Inspiring
February 11, 2021
Question

Issue while downloading Excel after using datetime

  • February 11, 2021
  • 2 replies
  • 0 views

Hi,

I am getting date and time in date field from data base. I am able to convert it to time using datetime(). 

I am using a!exportDataStoreEntityToCsv() to download the csv file but the issue is am not getting expected output. but when i place the cursor on that cell in csv file then am able to see the correct time. 

My requirement is that time should be displayed correctly without putting the cursor on that cell. Can someone help. Thanks. 

    2 replies

    J
    johnraphaela0002
    New Participant
    February 15, 2021

    I'm thinking this might be due to cell formatting. Have you tried formatting the value in Appian as text first before exporting to CSV using datetext() or text() function?

    A
    akshayg0006Author
    Inspiring
    February 17, 2021

    I have tried like this still no luck

     text(fv!row.time,cast( 8,datetext(fv!row.time, "default"))), 

    Can you tell the code 

    Terms & ConditionsAccessibility statement