topic How to change Today() to a date you can select in App Development

How to change Today() to a date you can select

GeorgeEard — Thu, 03 Oct 2024 09:51:24 GMT

I am trying to find out the amount of orders there were at a certain point in time

I have a dimension:

=If([Orders Order Date] < Today(), '1',

If([Contract Transfer Date] > today(), '1',

If([Contract Transfer Date] >= '-', '1', '0')))

I am currently using this which works but only for today. How could i change this so that any date in time could be selected and we could see how many orders we had at that time?

Thank you

Re: How to change Today() to a date you can select

PrashantSangle — Thu, 03 Oct 2024 10:13:16 GMT

you can store your selected date in variable & use that variable instead of Today

Re: How to change Today() to a date you can select

F_B — Thu, 03 Oct 2024 10:14:05 GMT

Hi @GeorgeEard , welcome to the community!

You can create a variable in the load editor and set it as today by default:

LET vDate=Today();

In your dimension substitute Today() with the variable:

If([Orders Order Date] < $(vDate), '1',

If([Contract Transfer Date] > $(vDate), '1',

If([Contract Transfer Date] >= '-', '1', '0')))

With a variable input in your sheet you can then choose a different date.

Re: How to change Today() to a date you can select

GeorgeEard — Thu, 03 Oct 2024 10:14:47 GMT

Thank you for your reply,

How would i do that?

Re: How to change Today() to a date you can select

GeorgeEard — Thu, 03 Oct 2024 10:29:47 GMT

Could I use the date picker to influence this variable?

Re: How to change Today() to a date you can select

PrashantSangle — Thu, 03 Oct 2024 10:36:44 GMT

yes you can. considering your date field name is cal_date

then try below

If([Orders Order Date] < date(max(cal_date)), '1',

If([Contract Transfer Date] > date(max(cal_date)), '1',

If([Contract Transfer Date] >= '-', '1', '0')))

check you date format while comparing or convert them in num then use it.

Regards,

Prashant Sangle