I've been wracking my brain trying to get this figured out, and all of the solutions that seem like they should work, aren't. I have a date field recorded as A10 (SQL: Char(10), Master File is A10) in my DB. I am attempting to convert it to MDYY format for filtering purposes.

Source Field called FROM_DATE, A10, '30/12/2015' is the example date.

From what I've been reading:

DATECVT (FROM_DATE, 'A10DMYY', 'MDYY') as a detail (DEFINE) field, or some similar variation, should work.

I keep getting blanks for the converted field.

I'm sure there's something ridiculously simple that I'm missing, but I can't find it. I'm openly welcoming someone to post the solution and make me look stupid!! Sorry if this is a repost, but I've been searching and experimenting all day...

This message has been edited. Last edited by: A Fisher,

FROM_DATE/A10 = '30/12/2015';
DATE1/A8MDYY = EDIT(FROM_DATE,'$$$99') || EDIT(FROM_DATE,'99') || EDIT(FROM_DATE,'$$$$$$9999');
DATE2/MDYY = DATECVT(DATE1, 'A8MDYY', 'MDYY');

Thank you very much, Tom Flynn!

This was the exact solution had been after.

Time to recommend the book "(Almost) 1001 Ways to Work With Dates in WebFOCUS" by Price and Perlmutter again.

quote:

Time to recommend the book "(Almost) 1001 Ways to Work With Dates in WebFOCUS" by Price and Perlmutter again.

yea, for only $127. Guess they didn't want to sell a lot of them.

http://www.amazon.com/Almost-D...-8-0-2/dp/1626207364

or $20 for the WebFOCUS 7 version.

Still not enough readily available content to search for.

I got my employer to buy a copy.

Yes, go with the 7 version for $20 http://www.amazon.com/WebFOCUS...rds=webfocus+7+dates

This is an essential reference guide for anyone who is constantly working with date conversions.

Also if there is a date format you are constantly converting to another I would consider placing a function on the server rather than coding it into every fex.

I had seen this book mentioned before, but saw only the higher priced versions.

Thanks for the reminder and finding the $20 copy!