Format Function And Minutes V Months

[yumbelie]

Any idea how you distinguish between months and minutes with the format function? The only example in the offline msdn reference I could find seems to demonstrate that it's context sensitive, e.g. hh:mm:ss is time, where as dd\mm\yyyy is a date. But this does not always seem to work. Is there no other symbol defined to represent seconds? like in PHP they use 'i' - or any workaround?

I'm masking a user string, which contains escape charcter sets which are replaced with date \ times, e.g. \dd\\mmmm\\yyyy is equivilent to format(now(), "dd\mm\yyyy") but, they of course use combinations, such as \\mm or \\mmmm etc, and the arbritrary use makes context sensitive searchs impossible.

Thanks

Yum.

 

[johnwm]

Use n for minutes in the Format function

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[yumbelie]

Thanks alot