How do I create a WebI variable to display the date including the milliseconds?
Version 4.2, SP7
Source database is SQL Server 2016
I have the variable below but can’t figure out how to add the milliseconds.
=FormatDate([Date Var];“yyyyMMdd HH.mm.ss”)
If Business Objects does support that level of granularity, the format is usually HH.mm.ss:sss if I remember correctly. It could also be HH.mm.ss.sss.
WebI does support milliseconds.
Format is:
24HR/military time: =FormatDate( [End datetime (EST)] ; “HH:mm:ss.SSS” )
12HR with AM/PM: =FormatDate( [End datetime (EST)] ; “hh:mm:ss.SSS A” )
Note, the format strings are case sensitive. You can adjust the SSS for your required number of places.
That is great! How did you figure this out? I cannot find any reference to milliseconds. This should be mentioned here.
Don’t remember 
It’s been on my “cheat sheet” for awhile.
Just submitted this idea…
Improved Custom Format Documentation To Include Milliseconds
Please check it out and consider voting for it.
Haha, received a notice from SAP Customer Influence on the improvement request before I received a notice about the BOB post. 
Oh, I voted for it.
Thanks, that worked.
