topic Re: Date variable -1 year in App Development

Date variable -1 year

Rick_T — Thu, 29 Aug 2019 13:21:05 GMT

Hello,

I want to make a date variable which stores another date variable -1 year.

The first date variable is a flexible one which the end users can fill in by them self. Then i want to make another variable which stores the date that the end user fills in -1 year.

So for example: the end user fills in 29-8-2019. The new variable needs to take that date -1 year which will result in 29-8-2018. Does anyone have an idea how I can achieve this?

Sincerely,

Rick

Re: Date variable -1 year

dplr-rn — Thu, 29 Aug 2019 13:34:04 GMT

Try below expression vInput is the variable for input

=Date(AddYears(Date#(vInput,'DD-M-YYYY'),-1),'DD-M-YYYY')

Re: Date variable -1 year

neelamsaroha157 — Thu, 29 Aug 2019 13:39:46 GMT

You can call the existing variable and use AddYears.

For example you have a variable vVar1 which takes the input date from the user then you can create a second variable as vVar2 = AddYears(vVar1, -1).

Re: Date variable -1 year

Rick_T — Thu, 29 Aug 2019 14:34:13 GMT

Hello, thanks for the reply. I am using the second variable as a filter within a set expression.

It should look something like this

sum(

{$<
Status -={'Canceled'},
Aanmaakdatum = {"<=$(vDateInput-1)"}
>}

[Kontr-afspr])

Where the vDateInput-1 is based on the original vDateInput.

Re: Date variable -1 year

Rick_T — Thu, 29 Aug 2019 14:37:19 GMT

Don't understand the calling a existing variable by addyears. I am trying this but it shows the original variable as a field not a variable. See below:

Re: Date variable -1 year

dplr-rn — Thu, 29 Aug 2019 14:38:20 GMT

change this to

Aanmaakdatum = {"<=$(=Date(AddYears(Date#(vInput,'DD-M-YYYY'),-1),'DD-M-YYYY'))"}

Re: Date variable -1 year

Rick_T — Thu, 29 Aug 2019 14:51:16 GMT

Thank you sir, works like a charm! 🙂

Re: Date variable -1 year

dplr-rn — Thu, 29 Aug 2019 14:55:42 GMT

No Problem