Jolene Kwek
Rank: #6386
88Views
7Comments
Solved
Default date set 1 year from CurrDate()
Question

Hi,

I have a entity attribute of DateCreated with the data type of Date. However, in my database, i want to set the default value as one year from CurrDate(). How do i express this correctly in the "Default value" input? 

0
0
on 2020-04-17
Copy link to comment
Lenon Manhães
Rank: #373
Solution

Hi, friend.

Normally you could use the function AddYears(CurrDate(),1) but it does not working as Default Value to attributes.

If you need to save this attribiute as one year from current date, just pass the function AddYears(CurrDate(),1) in your save methods, because I don't a way to set this value there as you want.


0
0
on 2020-04-17
Copy link to comment
Jolene Kwek
Rank: #6386

Hi Lenon and Salman

i think i will just use AddYears(CurrDate(),1), in the forms instead. Thank you for helping!


0
0
on 2020-04-17
Copy link to comment
Salman Ansari
Champion
Rank: #40

Jolene Kwek wrote:

Hi Lenon and Salman

i think i will just use AddYears(CurrDate(),1), in the forms instead. Thank you for helping!


Yes that why platform provide us the AddYears function.


0
0
on 2020-04-17
Copy link to comment
Salman Ansari
Champion
Rank: #40

Jolene Kwek wrote:

Hi,

I have a entity attribute of DateCreated with the data type of Date. However, in my database, i want to set the default value as one year from CurrDate(). How do i express this correctly in the "Default value" input? 

Hi Jolene


you dont want to pass createddate from frontend??

OR

If you have to pass createddate then you can do by AddYears(currdate(),1)


0
0
on 2020-04-17
Copy link to comment
Lenon Manhães
Rank: #373

I'm glad to help!


Best regards

0
0
on 2020-04-17
Copy link to comment
haslina sahar
Rank: #14444

Sir ,

Related to the above question, how if i want to calculate Year ( CurrentDate) - 1 years?

Thank you in advance

1
0
on 2020-11-18
Copy link to comment
Agno Silveira
Rank: #171


Hi haslina, follow the example:


AddYears(CurrDate(), -1)


Regards.

0
0
on 2020-11-18
Copy link to comment