Skip to Content
0
Former Member
Apr 25, 2007 at 05:23 PM

formatting date to exclude year

12 Views

Post Author: Set_Shot_Dave

CA Forum: General

I am pulling a birthdate field from my table, but I only want to print MM/DD.

I extracted Month(birthdate field)

and extracted day(birthdate field)

but when I concatenate the fields {@Month}&"/"& my result gives me 5.00 /20.00.

I've formatted the fields before concatenateing to supress ending zero(s).