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.
Discussion posts and replies are publicly visible
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?
I have tried like this still no luck
text(fv!row.time,cast( 8,datetext(fv!row.time, "default"))),
Can you tell the code