Skip to main content



No record found.

Microsoft Dynamics SL forum

Periods converted to Date

Posted on by 1,270

Hi Everyone

I need another push in the right direction for another report.  This one is a bit more complex.  I am attempting to do a trial balance report and I want to get the END DATE on the report, base on the period range chosen, but I am finding it a bit difficult.

For example, I ran the report between period 01 to period 02.  So I want to convert the periods to the start date and end date.  I was able to successfully get the start date (01/01) day/month but I am finding it challenging to get the end date (28/02).

Anyone got any ideas on how I could accomplish this?  Any help will be appreciated.

Thanks in advance

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,270 on at
    RE: Periods converted to Date

    Hi all

    Just an update; I was able to figure out this issue so I am now getting the end date on the report.


Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans