DTSToTimeString Query

[SDS100UK]

Hi,

I have a DateTime field and and want to group the field by half hour intervals

this is my formula

DTSToTimeString({VW_PER_LOGGING.LOG_DATE})[1 to 5]

But it keeps saying that a String is required just after the first bracket.

Can anyone help me? What string is required???

Is there an alternative way to get what I need??

TIA

Steven

 

[Reebo99]

Try this:

If DatePart("n",{VW_PER_LOGGING.LOG_DATE}) in [1 to 30] then
ToText({VW_PER_LOGGING.LOG_DATE},"dd-MMM-yyyy HH:&quot&"30" else
If DatePart("n",{VW_PER_LOGGING.LOG_DATE}) in [31 to 59] or
DatePart("n",{VW_PER_LOGGING.LOG_DATE}) = 0 then
ToText({VW_PER_LOGGING.LOG_DATE},"dd-MMM-yyyy HH:&quot&"00"

You can now group by this field.


Reebo
UK

"Before you judge a man, walk a mile in his shoes. After that, who cares? ...He's a mile away and you've got his shoes." - Billy Connolly

 

[SDS100UK]

Thanks Reebo,

However when I put it into my report it asks for " A number, currency amount, bolean or string" is required immediately after the "If" in the first line



Any ideas???

Cheers

Steven

 

[Reebo99]

ensure {VW_PER_LOGGING.LOG_DATE} is your field name.

Reebo
UK

"Before you judge a man, walk a mile in his shoes. After that, who cares? ...He's a mile away and you've got his shoes." - Billy Connolly