How to use interface date to formula

Question

Hi all,

how can i connect my date selection to the formula so that i dont have to manually key in the date to the formula? based on following formula , the variable is the  "2022-2-28 " i will need to manually update. Attached my workflow.

IIF([start_date]> "2022-02-28", 1,
DateTimeDiff("2022-02-28",[start_date],"month")+1)

thanks.

Interface Dates.yxmd

Qiu · Answer

@shijieleong 
then the app of mine should work for you.

shijieleong · Answer

Yes, i want to select the date from the dates tools instead of typing the dates each time .

Qiu · Answer

@shijieleong 
You mentioned interface, so meaning Analytic Apps?

Interface Dates.yxwz