Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Crystal Reports DatePart() Question

Options
  • 11-07-2005 2:46pm
    #1
    scojones
    Closed Accounts Posts: 7,230 ✭✭✭


    Hey guys,

    I've been googling for about an hour and can't find any relevant information on my problem. The problem is that I'm using the DatePart function like so: 
    DatePart("ww",{table.field})
    and I'm getting an error which says
    A boolean is required here.
    It's pretty irratating because it doesn't exactly say *where* the boolean is required :rolleyes:

    Anyway, I have tried different things with DatePart which I got from googling, I did a straight copy and paste, and it gave the same error. Has anyone experienced anything similar?
    I can post the entire formula if required.

    Thanks in advance!


Comments

  • Options
    #2
    scojones
    Closed Accounts Posts: 7,230 ✭✭✭scojones


    After removing the {} from around the table.field I get the following error
    "A number, currency amount, boolean, date, time, date-time or string is expected here", so I guess it's not recognising the field as a date.


Advertisement