
Hi All - I have a business rule set up to set the default date for one of my fields to be 1/1/1900 - when the rule runs though 12/31/1899 shows in the date field. I did some more testing with Power Automate and if I get the date from Dataverse Power Automate shows 1/1/1900 - and date I send back to Dataverse thru automation displays as the day before. If I manually enter a date it shows correct - just the automation does this. Base currency is yen.... if the international settings have anything to do with it. Created date on the records are USA CST tho.
All input welcome
thx
Is that Date Only field or Date/Time field?
I tried to set a Date/Time field with BR in my environment to 1/1/1900 00:00 but it is set as 1/1/1900 01:00 on the form.
I tried 1/1/2023 00:00 and it is the same issue and it sets the value as 1/1/2023 01:00.
It finally works when I set it as 4/3/2023 00:00 (which is the day after daylight saving switch in New Zealand)
For your case, I think it is set as 12/31/1899 23:00 behind the scene even though it is a date only field. And the value is correct when you get from Power Automate because it would return the UTC value "1/1/1900 05:00" by offsetting 6 hours.
Seems like the issue is more of daylight saving rather than time zone.
If it is a date only field and there is no solution, you might have to look for an alternative workaround like setting the default date with JavaScript or Power Automate cloud flow.