jbarber0020
6th October 2008, 15:18
I'm new to BAAN and can't get a grasp on this yet. I have a field
tdlit130.cart which is a date field and i'm trying to get the default set to current system date. Should I try and set this in the script editor or in the table tdlit130? Also how would I do this? I've tried utc.date() and a few other things but nothing is working.

Thanks

jbarber0020
6th October 2008, 16:07
Also... Sorry for the silly questions but i've basically been thrown into baan programming with no erp experience whatsoever. It's a whole new world. I keep getting error when I try to use date() function saying im not referencing it. Since i'm not familiar with baan I don't know how to fix this.

a_choudhury
6th October 2008, 16:07
Hi,

If you go to form editor select the date field from the layout which should open the session ttadv3101s000, check the default field and type the value date. This should show you the default date as today's date. You can also store the current date in the script using date.num().

Regards,

jbarber0020
6th October 2008, 16:24
I had tried that in the form editor but it never displayed the date when I ran the session.

jbarber0020
6th October 2008, 16:40
I had tried the form editor and that didn't work for me. The date.num() did work so I greatly appreciate your help. I had tried a lot of similar calls but my syntax was different.

Thanks

a_choudhury
8th October 2008, 13:36
Hi,

Did you type "date" in the form editor after checking the default field?

Regards,

bdittmar
8th October 2008, 14:11
I had tried the form editor and that didn't work for me. The date.num() did work so I greatly appreciate your help. I had tried a lot of similar calls but my syntax was different.

Thanks

Hello,

in form editor :

If the field is of type DATE the default value can be:

date(YYYY,MM,DD) : to have a specific date as default.
date() : to have the current date as default.
date +n : to have the current date + n as default.
date -n : to have the current date - n as default.

Zoom : No Default : Yes date()

Regards