Expand my Community achievements bar.

SOLVED

Is it possible to format Current Date?

Avatar

Level 1

I can format regular date fields w/o any problem, but the Current Date field (from the custom object library) seems to resist formatting. No matter what pattern I choose or enter in either the Display or Data tab, the date will only appear as 9/26/09. Is there some trick to formatting this object?

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

Go to the layout:ready event for the field and modify the date format.

The default FormCalc is as follows:

$.rawValue = num2date(date(), DateFmt(1))

Replace DateFmt(1) with the applicable format. For example,

$.rawValue = num2date(date(),"MM/DD/YYYY")

Steve

View solution in original post

2 Replies

Avatar

Correct answer by
Former Community Member

Go to the layout:ready event for the field and modify the date format.

The default FormCalc is as follows:

$.rawValue = num2date(date(), DateFmt(1))

Replace DateFmt(1) with the applicable format. For example,

$.rawValue = num2date(date(),"MM/DD/YYYY")

Steve

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----