Show a column on basis of two other columns

[yashcena]

I have a column named 'Release Filter'. Each Release Filter has a 'Release Title' and each Release Title has multiple SystemDate.

I have a requirement where I have to show the release title on the basis of SystemDate. For example, if today is 2017-08-04, then it should show that date's release title i.e. Aug 2017 Major. Basically, my computer's system date should match with 'SystemDate'

I hope I have made my requirement clear.

Thanks,

YASH

[Chanty4u]

systemdate is you database column or its system default field?

if you need max day of the date

try instead of system date  try with   max(systemdate)

[sunny_talwar]

Not entirely clear as to what you are looking to get... would you be able to share a sample where you can highlight the issue and the output you are looking to get (numerical output)

[arvind_patil]

Hi Yash,

With the help of addmonths you can achieve it:

=Date(AddMonths(Today(),-12))

Thanks,

Arvind Patil

[yashcena]

Hi Sunny,

SystemDate is a user entered column in the database. When this SystemDate matches with computer's system date, that day's release title should be displayed (in a text box).

Basically, everyday when the app will run, it will check which SystemDate matches with computer's system date and then select the corresponding Release Title.

For example, today is 5th July, so for 2017-07-05,  July 2017 Minor should be selected. On 13th July, i.e. 2017-07-13, Aug2017 Major should be selected as this is the Release Name for that date.

I also have to do the same thing for Release Filter. So for today i.e. 5th July, PI11 2017.08 should be selected which is the release filter for today.

Was this explanation helpful?

[sunny_talwar]

Explanation is good, but I have no clue what your chart is made up of... how your script looks... It might be difficult to help without a vision into those things