web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / BC Table Fields linked...
Small and medium business | Business Central, N...
Suggested answer

BC Table Fields linked to CRM Field

(0) ShareShare
ReportReport
Posted on by Johnson_Patrick 100

Hi,

I have a scenario where BC Table say "Table1" has "Field1" which is linked to the Field in the CRM Database. 

In the CRM Database, the field is of type "DateTime" which includes Date, Time & Time Zone in the field value. 

But in BC the same value is displayed as just Date. It doesnt contain Time nor the Time Zone.

Any Idea why this is happening? 

Also, is there a possibility to subtract Time from Date variable?

Thanks

Johnson Patrick

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 408 on at
    RE: BC Table Fields linked to CRM Field

    Hi,

    Yes, there is function that you can use to convert Datetime to Date using DT2Date(DateTime).

    Regarding TimeZone Business Central stores the time in DB in UTC

  • Johnson_Patrick Profile Picture
    Johnson_Patrick 100 on at
    RE: BC Table Fields linked to CRM Field

    Hi,

    Thanks for your input.

    Right, i know the function DT2Date(DateTime). But the primary problem being, data in the BC field is Date and not a DateTime. While in CRM its DateTime.  

    Any idea why?

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 408 on at
    RE: BC Table Fields linked to CRM Field

    Then you can use CreateDateTime(Today, 0T) function. Enter date in first and time if you need other wise 0T for 00:00

  • Suggested answer
    Greg Enns Profile Picture
    Greg Enns 1,106 on at
    RE: BC Table Fields linked to CRM Field

    Fields in both CRM and BC can be defined as either Date or DateTime. Apparently your BC field is a Date field.

    If you want BC to show datetime, then (1) create a DateTime field and (2) change the Field Mapping to point the CRM DateTime field to your new DateTime field in BC.

  • Suggested answer
    Greg Enns Profile Picture
    Greg Enns 1,106 on at
    RE: BC Table Fields linked to CRM Field

    Fields in BC and CRM can be defined as either Date or DateTime.

    Your CRM DateTime field is apparently mapped to sync with a Date field in BC.

    To change that, (1) Create a new Datetime field and then (2) update the Field Mapping to point the CRM field at your new DateTime field.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,791

#2
YUN ZHU Profile Picture

YUN ZHU 2,091 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 2,090

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans