Forum Academy Marketplace Showcase Pricing Features

Format as days empty

Hey,

I have a text that displays the age (from the date of birth with a formula) of a Paciente:
1

The thing is that I don´t know from where the format as days (18875.2) is coming from, becasue the fecha_nacimiento (date) is, and I suppose the final text has to also be empty.

Does someone knows where the 18875.2 is coming from?

Thanks in advance :slightly_smiling_face: :computer:

I don’t know where it’s coming from but I found this same issue :slight_smile:

I fixed it by adding a conditional that when ‘DOB input element’ is empty then initial content is 0 (or placeholder can be set to 0)

1 Like

Ok so the :format_as_days operator is taking your original subtraction and then converting it to the total number of days between the two dates. If your secondary fecha_nacimiento is NULL or empty, the calculation will return the number of days since EPOCH, which is Jan 1, 1970. This is not Bubble’s fault, it’s a way the underlying DB must handle dates.

FYI Bubble never actually stores a NULL date. It secretly stores it as the exact EPOCH time.

2 Likes

Thanks, @equibodyapp :grinning: :computer:

Thanks, for the explanation @jesse.r.hunter :grinning: :computer: