Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Created date time and modified date time table property

(0) ShareShare
ReportReport
Posted on by

Hi guys,

When we enable table's property created and modified date time of an existing table, with already exists data in it, the new columns will be populated with the date and time its enabled. Can we prevent this ? I mean can we make "not" fill in these date time ? so only the new records will have the information ?

Thanks,

  • VoltesDev Profile Picture
    VoltesDev on at
    RE: Created date time and modified date time table property

    Hi Girish,

    Noted. I just feel a bit strange of this behavior. For an existing data, which may be created years ago, then because I just enable it today, then the CreatedDate became today's date. Unfornately, in this table I don't have other date to make the "newly" column CreatedDate updated accordingly.

    However thanks again for your input.

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Created date time and modified date time table property

    I think this is the default behavior - It will set the time when it was enabled. Form my understanding I don't think there is any other way to restrict. As per the system if you enable created or modified by - Values for existing record will be either min date - max date - today date.

    So its considering date when it was enabled.

    Thanks,

    Girish S.

  • VoltesDev Profile Picture
    VoltesDev on at
    RE: Created date time and modified date time table property

    Hi Girish,

    Showing the date and time it was enabled. Which is in my case is today's date and time.

    Thanks

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Created date time and modified date time table property

    What values is it showing?

    Is this showing today date for both modified and created by column for existing records? Or actual date and time it was created and modified by?

    Thanks,

    Girish S.

  • VoltesDev Profile Picture
    VoltesDev on at
    RE: Created date time and modified date time table property

    Yes, I can confirm this.

    Thanks,

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Created date time and modified date time table property

    I am not sure with this - Basically if you enable create and modified date time - I guess it wont update for existing records.

    I guess it will populate all the existing records with today date time. I don't think there is any other way to restrict this. This is the default behavior as it is considering the date time when it was enabled for existing records.

    Can you confirm that the value showing in modified and created by column for existing record is correct or not?

    Thanks,

    Girish S.

  • VoltesDev Profile Picture
    VoltesDev on at
    RE: Created date time and modified date time table property

    Hi Girish,

    Yes, that's what I experience now. Is it the correct behavior ?

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Created date time and modified date time table property

    Hi VoltesDev,

    Are you saying that created and modified date for existing record is populated with the some vales after enabling it.

    Thanks,

    Girish S.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans