Answered

Why, when I don't enter a date, does it get recorded as 12/31/1969?

(1) Share

Report

Posted on by futr_vision

831 Moderator

I have a form where the end date field is optional. However, if nothing is entered, it gets recorded as 12/31/1969. How do I avoid that?

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi

Could you please give a bit more information about the database? Dataverse or Sharepoint?

Thanks

Was this reply helpful? Yes No
lbendlin 8,703 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

That's the first Unix date, plus/minus your timezone.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (1)

Report
Copy link

Link copied!

This is a Dataverse table

Was this reply helpful? Yes No
ronaldwalcott 3,866 Moderator on at

Like (1)

Report
Copy link

Link copied!

The field should store a blank value in your Dataverse table if nothing is entered but would display in the form based on the placeholder value

If(IsBlank(Self.SelectedDate), Text(Date(2001,12,31), Self.Format, Self.Language))

Is this value actually stored in the table or is the date column blank?

If this value is stored then you setting it as a default value somewhere.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (1)

Report
Copy link

Link copied!
@ronalwalcott

This is what I have for the InputTextPlaceholder for that field

If( IsBlank(Self.SelectedDate), "No End Date", Text(Self.SelectedDate, Self.Format, Self.Language) )

DeafultDate is Parent.Default

The datacard Default is

If ( varCopy, glbFormData.dk_enddate, ThisItem.'End Date' )

When I do not enter a a date in the end date field then it gets written to the table as 12/31/1969

Was this reply helpful? Yes No
ronaldwalcott 3,866 Moderator on at

Like (1)

Report
Copy link

Link copied!
Are you using SubmitForm to save data or Patch?

Is there any code in the form OnSuccess property?

What are these values?

varCopy, glbFormData.dk_enddate

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (1)

Report
Copy link

Link copied!
The initial submission it is a SubmitForm. I do use a Patch on the OnSuccess of the form but that is for something else. Here is that code.

Patch( 'Placement IDs -DEVS', LookUp('Placement IDs -DEVS', 'Generated Placement ID' = LBL_TempPlacementID.Text) , {'ID Used': "Yes"} ); UpdateContext({varShowSpinner: false}); UpdateContext({varCurrency: Blank()}); UpdateContext({varCurrentTab: "CampaignDetails"}); Navigate(Success)

The last bit of code you are asking about if for a global variable. If the user decides to copy the record, I grab the record and put it in the global variable and navigate them back to the initial form and populate the form with the global variable data. The code you posted there is for the end date which ends up getting filled in as 12/31/1969 since that is what is being written to the Dataverse table.

Was this reply helpful? Yes No
ronaldwalcott 3,866 Moderator on at

Like (1)

Report
Copy link

Link copied!

Based on your response the problem is probably with the global variable. How are the global variables set and reset? Try removing the If and test to see if that is the cause of the problem.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hmm. Just the presence of a global variable, even if it is empty, would cause this issue?

Was this reply helpful? Yes No
ronaldwalcott 3,866 Moderator on at

Like (1)

Report
Copy link

Link copied!

It wouldn't but are you tracking the state when you are testing? If not, removing it would immediately indicate if it were the cause.

Was this reply helpful? Yes No