"\#mm\/dd\/yyyy\#"

[a.phillips]

Hi i was just woundering if anyone has seen this before, and if so could you explain what it does.

Thanks

Const strcJetDate = "\#mm\/dd\/yyyy\#"

 

[vbaInet]

Do you know what this does "mm/dd/yyyy" is? If you do it will be easier to explain.

Also, it's explaining what it is for (not what it does) would depend on the context it's being used.

 

[pbaldy]

This should explain it all:

http://allenbrowne.com/ser-36.html#Format

 

[vbaInet]

Ah, forgot about that. Good one Paul.

 

[gemma-the-husky]

so you will be using this to format your dates, to avoid date ambgiuity in locales that do not use mm/dd/yy (standard US microsoft method)

format(somedate,strcJetDate)

but out of interest, depending on your locale, you can probably get the same reliability with this, which is easier to remember!

format(somedate, "long date")

 

[a.phillips]

Thanks for all the replies. This was used in code to try and get the date format correct, but didn't seem to be working fully! I'll have a good read through that webpage.

Thanks for everyones help