This topic is locked

Custom Date

6/29/2013 6:47:54 PM
ASPRunnerPro General questions
F
fenhow author

Is there any way to create a custom view for a date. I am looking for 29 June 2013 format.

Thanks.

Fen

Sergey Kornilov admin 7/1/2013
F
fenhow author 7/1/2013



Check VBScript date functions like FormatDateTime: http://www.w3schools.com/vbscript/func_formatdatetime.asp

Other useful functions: http://www.w3schools.com/vbscript/vbscript_ref_functions.asp



Thank you. I looked at the page but do not see how I can add one of those items to the Custom View for the date to make it show what I want. I am not very expierenced at this, can you please send me an example? I would like my date to read 1 July 2013 without the time etc..

Thanks.

fen

Sergey Kornilov admin 7/5/2013

Example for 'View as' custom:

strValue = FormatDateTime(strValue,1)


More complicated example:

d=CDate(strValue)

strValue = Day(d) & " " & MonthName(Month(d)) & " " & Year(d)