cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Common Data Service (current environment) - Setting Date Only Fields

Hi Experts,

 

I am running a flow to create new records in the Common Data Service (CDS) and yes, I know it is Data Flex Pro now :).  


The problem is that if I set a Date Field on an entity it is not setting to current

 

Date from Account entity:

date_on_account_entity.PNG

Date on new record when I set the value like the following (the Package Begin Date from the Account entity) and this field is defined as "Date Only".

setting_field.PNG

 

On the create you can see it is setting to the 8/1 date but with a UTC time and no timezone offset.  This field is also a "Date Only" field on the entity.  

date_on_create_of_record.PNG

 

It seems like I have to do a lot of work here just to set one date field to another date field across two entities correctly.  Does anyone have thoughts here?  

 

Thanks much!


Drew

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Common Data Service (current environment) - Setting Date Only Fields

Please use formatDateTime expression convert a datetime to a specified format, and use convertTimeZone expression to update the datetime to specified timezone.

View solution in original post

9 REPLIES 9
Highlighted
Super User III
Super User III

Re: Common Data Service (current environment) - Setting Date Only Fields

Hi @dpoggemann 

 

Not fully understood your issue here. I can see the dates are mapped correctly which is 2020-08-01. Did you tried to retrieve the date from Account Package Services and see if values are showing any different or not?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Microsoft
Microsoft

Re: Common Data Service (current environment) - Setting Date Only Fields

I suppose you want to know how to manipulate values of ind_packagebegindate and ind_begindate because of the value differences.

You can try to use formatDateTime expression convert a datetime to a specified format and manipulate the values.

Highlighted
Frequent Visitor

Re: Common Data Service (current environment) - Setting Date Only Fields

The date on the entity for the newly created record is set to 7/31/2020 vs. 8/1/2020.  This is the issue I am having...  I am doing no calculations at all, just taking the date from the Account record and storing on the new entity and they are both defined as Date Only fields.  The Account's date shows 8/1/2020 while the newly created record shows 7/31/2020.

 

Any ideas?

 

Thanks,


Drew

Highlighted
Frequent Visitor

Re: Common Data Service (current environment) - Setting Date Only Fields

HI Chris,

 

So we are in central time zone, are you saying I need to use formatdatetime on every date I am working worth and make sure I am setting the field with the timezone offset for Central?  Can you give me an example what you would do in this situation?

 

Thanks!

Highlighted
Microsoft
Microsoft

Re: Common Data Service (current environment) - Setting Date Only Fields

Please use formatDateTime expression convert a datetime to a specified format, and use convertTimeZone expression to update the datetime to specified timezone.

View solution in original post

Highlighted
Frequent Visitor

Re: Common Data Service (current environment) - Setting Date Only Fields

Thank you, I will utilize these functions to accomplish as this is what I have been doing because there was no option.  Overall I see this as a bug since I am taking a Date Only field from the instance and mapping it directly to another date only field, there should be no reason that I have to do this conversion on creation of the new record.

Highlighted
Microsoft
Microsoft

Re: Common Data Service (current environment) - Setting Date Only Fields

I would suggest you raise a ticket to Microsoft Support if you really have concerns of the datetime value to confirm whether it's a product issue or due to some configurations. If it's a product issue, Microsoft will fix it in the future release.

Highlighted
Frequent Visitor

Re: Common Data Service (current environment) - Setting Date Only Fields

Will do.  Thanks!

Highlighted
Super User III
Super User III

Re: Common Data Service (current environment) - Setting Date Only Fields

Hi @dpoggemann 

 

I don't think it's a bug. Could you please check CRM > Settings > Options

 

image.png

 

 

Check the time zone settings

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,227)