Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leeperman
Starting Member
2 Posts |
 Posted - 2013-10-10 : 06:49:24
|
| Hi,I try and dipslay date as a header on the top of my page. It needs to be in the format YYYYMMDD_HHMMSS.I use expression =FormatDateTime(NOW(),'%Y%m%d_%H%i%s')but recieve errorThe Value expression for the textrun ‘ID3.Paragraphs[0].TextRuns[0]’ contains an error: [BC30201] Expression expected.If i use =FormatDateTime(NOW()) the date displays but not in the correct format.Can someone please help where im going wrong in the date format expressionThanksCiaran |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2013-10-10 : 08:11:15
|
looks like this isn't a T-SQL problem!?
Too old to Rock'n'Roll too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-10 : 08:33:27
|
| Should be this=Format(Now(),"yyyyMMdd_hhmmmss")------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Display Date YYYYMMDD_HHMMSS