I have a gallery that has a date field from a SQL data source that I want to have a conditional fill color applied based on the date being equal to a selected date on the main screen. This works fine in development mode and run mode in Windows. When I open the app in an iPad or iPhone, the fill for all date fields is black. Here is the logic to pick color:
If(IsBlank(ThisItem.Stock_Date), White, // This checks to give default color if no date value
// if there is a date value, test if the gallery field date is equal to selected date
If(DateValue(Text(ThisItem.Stock_Date,"[$-en-US]yyyy//mm//dd"))
=
DateValue(Text(DatePicker1.SelectedDate,"[$-en-US]yyyy//mm//dd")) ,
Yellow, // if dates are equal, Fill will be Yellow
White) // if dates are not equal, Fill will be White
)
Example from Windows run shows below as I want it with yellow fill for date when 08/05 is selected from date picker control on main screen.
But on iPad, fill will be black for all date fields in gallery.
Any help?
