Date Picker showing blank for all

Hello,

I am trying to populate a date picker control with a date from my data source within a gallery.

Within the data source not every row in the Date column has a date currently assigned to it.

I was hoping that through this formula that i found on another topic on this site it would allow me to have blank values assigned to rows, and not produce the error "Expected Value " to be a valid RFC 3339 'date-time format'."

IfError(IsBlank(Text(DateTimeValue(Gallery1.Selected.'Work Start Date'),"dd-mm-yyyy")),Blank(),Text(DateTimeValue(Gallery1.Selected.'Work Start Date'),"dd-mm-yyyy")
)

Using the above, the date picker is no longer returning any of the dates and is showing all as blank.

Any ideas / corrections to the formula is very much appreciated.

Many thanks

Chris

Categories:

Using Apps Using Formulas

General Questions