DateDiff() Usage 1

[Michael42]

Hello,

I am struggling when using DateDiff() with date the values in a variable in the format of "yyyymmdd".

Do you have to convert a Date to a certain format or "Date" data type to properly use DateDiff()?

Thanks,

Michael42

 

[webmigit]

Always eight digits?

<cfset nDate = "20050117">
<cfset propDate = mid(nDate,5,2) & "/" & mid(nDate,7,2) & "/" & mid(nDate,1,4)>

<Cfoutput>#DateFormat(propDate,"dddd, mmmm dd, yy")#</cfoutput>

Try that.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[Michael42]

webmigit,

Cool - think I just needed to see it in that form. I have it working now.

Thanks for posting,

Michael42