[CustomMasks] defualt invalid input

[CustomMasks] defualt invalid input

  
Forge Component
(17)
Published on 14 Sep by Jogait
17 votes
Published on 14 Sep by Jogait

i used this on my own enironment, and everytime I input the date, it always input an invalid default value of "1900-00-00" on my database.

Can anyone help me? 

Thanks,

-Daryl

Hi Daryl.

Can you share an example of the way you used this? And the default value isn't "1900-01-01"?

Daryl wrote:

i used this on my own enironment, and everytime I input the date, it always input an invalid default value of "1900-00-00" on my database.

Can anyone help me? 

Thanks,

-Daryl

Hi Daryl,

If you are using outsystems database default value will be stored as 1900-01-01. 

Write server action (Enable as Function), 

in this add input parameter as Date,output as string,

Assign empty if date is 1900-01-01.

If(Date="1900-01-01","",FormatDateTime(Date,"dd-MMM-yyyy"))