Hi Everyone! I've always found this to be the best source for help when I get stuck, but now can't find any resources to get out of a jam.
I have a table where I am trying to generate a work order number that is formed by concatenating several fields. One of the fields is a Work Order generations date formatted as yyyymmdd. When I concatenate this into my work order number, this date reverts to the "standard" format as mm/dd/yyyy. I have tried to change the format property within the concatenated number, but to no avail.
Is there a way to maintain the yyyymmdd format after concatenating?
Thanks for all your help!
I have a table where I am trying to generate a work order number that is formed by concatenating several fields. One of the fields is a Work Order generations date formatted as yyyymmdd. When I concatenate this into my work order number, this date reverts to the "standard" format as mm/dd/yyyy. I have tried to change the format property within the concatenated number, but to no avail.
Is there a way to maintain the yyyymmdd format after concatenating?
Thanks for all your help!