topic Re: VBScript label expression for dates. in ArcGIS Enterprise Portal Questions

VBScript label expression for dates.

PaulHuffman — Tue, 12 Jun 2012 18:04:54 GMT

I thought I could reformat a date variable to drop the year for a map label but all I can get from the label expression advanced box is "The expression contains an error. Modify the expression and try again." Tried

FormatDateTime([StartDate], 1)

and

Function ShortDate ( [StartDate] )
ShortDate = FormatDateTime([StartDate],1)
End Function

where StartDate is a date item in my table formated mm/dd/yyyy For the second FormatDateTime argument, I've tired 1 and 0.

Re: VBScript label expression for dates.

KenBuja — Tue, 12 Jun 2012 19:14:21 GMT

I'm able to get the formatted date for my date field [SUR_DATE] in the label using the line

FormatDateTime([SUR_DATE])

To drop the year, I had use the syntax

Month( [SUR_DATE] ) & "/" & Day([SUR_DATE])

Re: VBScript label expression for dates.

PaulHuffman — Thu, 14 Jun 2012 00:19:44 GMT

Thanks, Ken, that's working for me.

But the other thing I was trying to do to make the same label was to create a new item and use the field calculator and python to calculate the shorter date string. I thought I knew more about python but I couldn't get the syntax right. It seems like you'd use strftime, but maybe it doesn't work because the source item is already a date, not a string.