[closed] InitValue and WORKDATE?

jversusj

hello everyone. I searched the forum but didn't find anything on this.

I want to put a custom date field on my item table. I would like to put an InitValue := WORKDATE, so that anytime a new item is created, the system logs the date it was entered, and I'm trying to do it without asking our NSC to put code behind the table or form.

I found that InitValue will let me define the date as a day of the week, but it doesn't understand TODAY or WORKDATE. Since i'm looking for an accurate date, the weekday doesn't help much.

Is there a syntax for defining InitValues of Date fields, beyond Sunday..Saturday?

thanks!

matttrax

I don't know of a way to do set the init value that way. I've always done it with code.

If you have access to the code, just go to the onInsert method and type

myNewDateField := WORKDATE;

Savatage

It's as easy as:
Creating a field called "Start Date" Type Date

On the item table add

OnInsert()
"Start Date" := WORKDATE;

Unfortunately It is not possible without access to the c/al code

Savatage

2 post - perfect timing!

DenSter

and the same answer too

jversusj

thanks gentlemen. alas, i have no access to table code.

looks like i'll have to give the NSC a job.

Savatage

hopefully they don't round up to the hour when charging you.

It a 2 minute job!

jversusj

Savatage wrote:

hopefully they don't round up to the hour when charging you.

It a 2 minute job!

yeah. i know. that's why i wanted to do it.

usually they round to 15 minutes, so not so bad.