YTD date range selector

I'm trying to get date selector interface for my end users so they will be able to define YTD date range on their side (1-OCT up to first day of month)

The issue I have is how to setup the expression part so it would be captured by interface buttons.

Range YTD.yxmd

Tips and Tricks

Date Time

Transformation

Apps

Interface Tools

Accepted answers

patrick_mcauliffe

@marcin2x4 Again, you'll probably have to modify this to suit your specific need; but attached is how I would do it if you want the user to be able to select both start and end months.

Range YTD_edited.yxwz

All comments

patrick_mcauliffe

For the most part it looks like you have it set up correctly - just maybe some extra tools.

I would just use a single Date interface tool, connected to one and only Filter tool.

If it is always going to be YTD then you could use a formula like this:

[Date]>=(ToString(DateTimeYear('2018-01-01'))+'-01-01')
And
[Date]<DateTimeTrim('2018-01-01','month')

Have the Update tool replace 2018-01-01 with the date coming in from the Date Interface tool.

Range YTD_edited.yxwz

marcin2x4

@patrick_mcauliffe - you file is not working, could you re-send ?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335