Unable to Save Blank Date in Dataverse for Teams Using SubmitForm Function

[jpalecek]

I am building a Power Apps application in Teams and using Dataverse. I have a table that has Optional Date Only column. On my form, when testing the value in the date field using the Blank() function it returns True. After successfully submitting the form to create a new record, the value in the date fields is set to 12/31/1899, not Blank as desired.

If I edit the record, remove the value in the date field, and submit the form, the date value in the table is set to 12/31/3799. I simply want the date field to be blank until the user selects the date picker and chooses a date value.

It seems like this would be a common issue, but I have searched and not found anything specific to this behavior. If you have experienced this as well and have a solution, I would appreciate your help. Thank you.

[v-qiaqi-msft]

Hi @jpalecek,

I have made a test on my side, and I don't have the same issue with yours.

In addition, could you please tell me that what is the Optional Date Only column? I have a Date column in my scenario and it works as expected.

[jpalecek]

Hi Qi,

I have a table with a "Date Only" column.

On the form, the Date Value Picker sets the value to Blank when the form mode = New.

When I run the app and insert a new record, I do not populate the date field. 

But when the record is saved, a value of "12/31/1899" is set for the date value, not Blank as desired.

Please let me know if I can provide any further details. Thank you.

Jim

[rampprakash]

Hello @jpalecek 

That's Strange, its setting blank date for me 

Am using Submitform(formname)

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[jpalecek]

I have found that it works as desired (date value is Blank) when I replace the SubmitForm function with the Patch function.

It would be good to understand why and what is happening behind the curtain with SubmitForm.

[jpalecek · Accepted solution]

I have found that the issue is resolved by changing the Behavior property in the Date Only field from "User Local" to "Date Only". This is found in the Advanced Options section.

I did have to delete and add the field back to the form as well. In doing so, I noticed that the Hour and Minute values are now excluded from the data card.

Thank you to everyone who looked into this matter. Best Regards.