var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: A simple date display question
Please have a look at the following statement in control source of a test box
="Q" & [ReferenceNo] & -Format(Date()," yy")
If [ReferenceNo] = 25
The output I get is
How can I make it to show
Why don't you try this??
- Right$(Year(Now()), 2)
Hope it helps.
Thanks for your reply
Not working as required
Any more suggestions
Ok, how about this then??
Dim strDate as string
strDate = Right$(Year(Now()), 2)
="Q" & [ReferenceNo] & "-" & strDate
If this doesn't work, may I suggest you look at your time/date setting and just check what format your short date is in.
="Q" & [ReferenceNo] & "-" & format(year(Date(),"00"))
I have treid Daveo61's solution and it is working perfectly well.
Thank you for your help