Hi Jason,
I got *really* tired of trying to guess what was going to happen when a string was parsed by the various CF functions so I wrote my own. It treats the string as a list (as suggested by Paul), supports "/", " " and "-" as delimiters and will handle months in short name format. The string must be in the order day/month/year or day/month.
If you haven't found a solution let me know and I will send you the code, or I'll post it somewhere if enough people are interested.
Regards,
Brett B)
Jason Bayly wrote:
Can anyone explain to me why when i LSParseDateTime('21-5-2004') i get an invalid date format ?
Whats the deal with that when its a valid date format.. If i take it out i run the risk of dates ending up in the DB in US format.. I guess i could detect the dashes and replace them with the slashes, but doesnt seeem very elegant.
Anyone got any ideas? Im probly having a blonde moment. no offense.. :-s
Jason
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
