cancel
Showing results for 
Search instead for 
Did you mean: 

Change date field to a default date

Former Member
0 Kudos

Hello,

my requirement is such that i need to have a Valid to Date as 31/31/9999,

I tried using left(systime(0),11) which will give me for eg, 12/10/2010, which i need to change to 31/31/9999

How do i achieve this.

thank you in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Abhishek,

1stly, please correct your default date as there is no month of 31.. in MM/DD/YYYY. Mention the exact default month are you looking for. I am assuming you want your Default date as 12/31/9999 for DateField.

So if you want to populate DateField as 12/31/9999.. Create an assignment and assign DateField as assignment field and in expression write 3067670, it will populate automatically DateField as 31 Dec 9999 in your required format.

Kindly mark thread as answered if it solves your query.

Regards,

Mandeep Saini

Former Member
0 Kudos

when ever i run my assignment, in Date To field in the assignment I get 01/01/1601 which is incorrect, what i need is 31/12/9999, by default when ever i run my assignment

Former Member
0 Kudos

Hi Abhishek,

Have you tried with assignment expression as i said above: 3067670

When you run assignment, Please write in Expression as 3067670 and let me know what output are you getting.

Regards,

Mandeep Saini

Former Member
0 Kudos

Thanks Mandeep Saini, it has solved my issue, i am getting the desired output, would you please explain the logic behind writing 3067670 in the assignment expression

Answers (0)