var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Julain Date and Sequential Numbers
I need some help writing a code that would start off with the current julian date and then have a 3-digit number. ie, 4078-001.
Then as each new record is added the number would increment by by 1 ie, 4078-002, 4078-003.
I would like it to not leave any spaces and also it would have to start over at 001 on the next julian date. ie, 4079-001.
Does anyone have any ideas on how to do this??
I would use something like this:
get the julian date using the format function if needed
cnt = nz(dmax("right([id],3)","YourTable","[id] like " & jdate & "*"),0)
id = jdate & "-" & cnt + 1
Can't seem to get Dmax to work am I missing something.?
You have to replace some of the words with those in your database
Yourtable = the table name with the data
id = the name of the field in the table
jdate = a variable or field name with the desired julian date without the "-001"
Are you getting an error message or is it just not returning the right value?