News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... concatenate Filename w...

Finance | Project Operations, Human Resources, ...

Suggested answer

concatenate Filename with date and time export to csv

(0) Share

Report

Report

Posted on by Ram Kumar

442

Hi ,

I need to export table data to a csv file. But I have to save the filename with some name concatenate with current date and time

For ex: Purchaseorder22/01/202106:22:20. Help me on this.

Regards,

Ram

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 230,476 Most Valuable Professional on at

Like (0)

Report
RE: concatenate Filename with date and time export to csv

If you're not afraid of .NET Interop, it can be very simple. Something like this:

System.String::Format('PurchaseOrder{0:dd/MM/yyyyHH:mm:ss}', dateTimeValue);

Note that including colon in file names doesn't look very wise to me.
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: concatenate Filename with date and time export to csv

Hi Ram Kumar,

You can try the code as per this post.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,784 Super User 2024 Season 2

#2

Martin Dráb 230,476 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans