Gallery only showing events occurring at midnight

[charliejbird]

Hi all,

My issue is with a nested gallery I am using to create a calendar. The nested gallery shows events that match the date label for each day using the following formula;

Filter(colEvents,InitialApptDate=DateValue(DateLabel.Text))

However my issue is that it will only show events that occur at midnight. Does anyone know a solution so that the gallery will show events that occur at any time?

Thanks

[PG_WorXz10]

Hi @charliejbird ,

Just to check does your database field which you are refereeing contains 12:00 AM as time parameter like in case of Sharepoint if you make dateTime field as Date only it stores everything with default time 12:00 AM. Is something like this happening in your side ? 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[charliejbird]

The database field is a DateTime field and different records have different times. However, it is only showing the records with the time 12:00 AM. I assume because the  DateValue of the DateLabel is defaulting to 12:00 AM.

[PG_WorXz10]

@charliejbird 

Yes, you can cross check with the database data if this is the condition.