Associating Date Range Picker with a Date field and Status field

[Arvind_Singh]

Hello everyone,

I am trying to build a dashboard where I need to associate a date field and status field in Date Range picker.

Below is the sample data

Order No	Order Status	Date
45678	Done	24/10/2022
98765	In Progress	1/9/2022
34567	Done	17/08/2022
56765	Scheduled	31/10/2022
23564	Done	31/10/2022
98764	In Progress	5/11/2022
87656	In Progress	13/12/2022
87887	Done	18/12/2022
76152	Scheduled	21/12/2022
92560	Done	11/1/2023
67654	Done	21/03/2023
980976	In Progress	22/02/2023

So if the user selects a  date range for example (1st October 2022 - 31st Dec 2022), the field Status with Value "Done" should get selected automatically.
Is there an expression that can be used to get the desired output as -

Order No	Order Status	Date
45678	Done	24/10/2022
23564	Done	31/10/2022
87887	Done	18/12/2022

[Or · Accepted solution]

It seems like you're looking to create an additional date field with the condition If([Order Status] = 'Done',Date) as SelectionDate?

[Arvind_Singh]

Thank you!!

if one of the Date field contains a NULL value (no date)  but status field contains "DONE", is there a way to display that row?

[Or]

You could replace the null with something else using Coalesce() or another if() statement, but if it wasn't a date, the entire field would stop behaving as a date.