Date Format

[Legion13]

Is there any way to set the date format in Sequel Server 7 to only use the month and year, e.g. 09/2000?
[sig][/sig]

 

[crystalized]

I can tell you that a little while ago I asked the same question. The answer I got is that you can not control how the value is saved in the database.

You can however control how you retrieve it etc.

I personally used a stored procedure to retrieve the date using this (maybe not the best way to do this but it was the way I figured out):

Left(DateName(mm,ptlSubstPerf),3)+'/'+DateName(yyyy,ptlSubstPerf)

This gives me Jan/2000. Now I think there is also a DatePart function that can give you the numbers for the month instead of the name.

Hope this helps. [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]

 

[Legion13]

Absolutely. At the very least it lets me know that I can stop wasting my time looking for nonexistant commands. I will try out your code and see what I can do with it. Thanks for your time and input.
[sig][/sig]