How to use interface date to formula

[shijieleong]

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. 

[binuacs]

@shijieleong 

IIF([start_date]> DateTimeLastOfMonth(), 1,
DateTimeDiff(DateTimeLastOfMonth(),[start_date],"month")+1)

[AngelosPachis]

Hi @shijieleong 

Do you mean how you can use a Date interface tool in your workflow so you can have a calendar to select the date rather than manually typing the date each time?

[Qiu]

@shijieleong 
You mentioned interface, so meaning Analytic Apps?

[shijieleong]

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

[Qiu]

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