Hello all,
I am seeking help with a format for a calculated field which can be seen in the attachments
I use the calculation [field1] & [field2] & [field3] & [field4] & [field5]
field 1 is a number, field 2 is a date, field 3,4 and 5 are numbers.
The calculated field displays the following format
1/1/1/2015/2/3/4
with a format @\/@@@@@@@@@\/@\/@\/@
:banghead:
The format that I would like to display in my calculated field is
1/010115/2/3/4
1 being the field 1 number,
010115 being the date ddmmyy,
2 (field3)
3 (field4)
4 (field5)
Many thanks in advance!
I am seeking help with a format for a calculated field which can be seen in the attachments
I use the calculation [field1] & [field2] & [field3] & [field4] & [field5]
field 1 is a number, field 2 is a date, field 3,4 and 5 are numbers.
The calculated field displays the following format
1/1/1/2015/2/3/4
with a format @\/@@@@@@@@@\/@\/@\/@
:banghead:
The format that I would like to display in my calculated field is
1/010115/2/3/4
1 being the field 1 number,
010115 being the date ddmmyy,
2 (field3)
3 (field4)
4 (field5)
Many thanks in advance!