Please ignore my earlier email. The below expression worked
${EVENT_TIMESTAMP:toDate('yyyy-MM-dd HH:mm:ss'):format("w", "GMT")}
On Wed, Feb 3, 2021 at 11:16 PM KhajaAsmath Mohammed <
[email protected]> wrote:
> This didn't work. Am I missing something?
>
> EVENT_TIMESTAMP
> 2020-07-10 23:46:14.805
>
>
> ${EVENT_TIMESTAMP.value:toDate('yyyy-MM-dd HH:mm:ss'):format('w')}
>
>
> Thanks,
> Mohd
>
> On Tue, Feb 2, 2021 at 8:29 AM Mark Payne <[email protected]> wrote:
>
>> You should be able to use something like:
>>
>> ${field.value:toDate(‘yyyy-MM-dd HH:mm:ss’):format(‘w’)}
>>
>> Thanks
>> -Mark
>>
>> > On Feb 1, 2021, at 9:13 PM, KhajaAsmath Mohammed <
>> [email protected]> wrote:
>> >
>> > Hi,
>> >
>> > Is there a way to get weekofyear from the query record processor. Any
>> syntax would really help.
>> >
>> > Time stamp: 2021-02-01 12:12:12
>> >
>> > Thanks,
>> > Khaja
>> >
>> > Sent from my iPhone
>>
>>
