Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

concatenate Filename with date and time export to csv

Posted on by 434

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

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    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 Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: concatenate Filename with date and time export to csv

    Hi Ram Kumar,

    You can try the code as per this post.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans