Short Date in Formula Field

Similar Threads:

1.formating a date field inside of a "Formula Field"

I have created a formula field which prints brackets around a date if the 
date is a required date in my report  (eg  [  1/6/2005  ] ).  However, I 
want to format the date in mm/dd/yyyy format.  (eg  [  01/06/2005  ] ).  the 
formula is as follows:

if {ReqdCourses.Cmp1date} > #01/01/1901# then "[  " & {ReqdCourses.Cmp1date} 
& "  ]" else "      "

any thoughts?

Thanks,

Bill V 

2.changing short date time setting mangles the date seperator

Hi

I have the following code in my app - it is supposed to change the short
date format style to dd/mm/yyyy
it does this unfortunately it also mangles the date seperator changing it
from / to /mm/ any ideas why this is happwning ?

this happens on win98 and is ok on win2k and xp

Silk



Public Const LOCALE_SSHORTDATE = &H1F
Public Declare Function GetSystemDefaultLCID _
        Lib "kernel32" () As Long

Public Declare Function SetLocaleInfo Lib _
     "kernel32" Alias "SetLocaleInfoA" ( _
     ByVal Locale As Long, _
     ByVal LCType As Long, _
     ByVal lpLCData As String) As Boolean


Public Function locale_change()
    On Error Resume Next
    Dim lngLocale As Long
    lngLocale = GetSystemDefaultLCID()
    Call SetLocaleInfo(lngLocale, LOCALE_SSHORTDATE, "dd/mm/yyyy")
End Function

3.Error with formula fields- the remaining text does not appear to be part of the formula

Hi,

i want to fill some formula fields.
I added my formula fields in the report with -> unbound fields, string. In
my report it is named [@UnboundString1].
So i tried to fill these fields with:

Dim crReport As New CrystalReport1

crReport.DataDefinition.FormulaFields.Item("UnboundString1").Text = "a"

Me.CrystalReportViewer.ReportSource = crReport

When i try to run this, i get these error message :

the remaining text does not appear to be part of the formula .... ?

I tried to set the text to a number like 1, this works !
So what is my fault ???

Kind regards,

Hans

4.Using Formula Field Names within a formula

Anyone ever try to use part of the Formula Field name within the formula?

For example:
Formula Field "Day01"

if day({table.entrydate}) = val(right(formulaname,2)) then
    ....
else
   ....

I know I can hard code the formulas, but I have 10 sets of formulas to build 
and I am feeling really lazy.

TIA
Rob 

5.Returning a short date in a datareader

Hi,
I have the following however the date is returned in the long format. I want 
to display as dd/mm/yyyy.

            If Not drReader.Item("offerstatusdate") Is DBNull.Value Then
                txtOfferStatusDate.Text = drReader.Item("offerstatusdate")
            End If
Regards

6. How to Get Short Date Format Pattern?

7. Short Date Format

8. Retrieving short system date format in VBA