date format conv

[qvqfqlik]

how to convert a date year week format of a field

existin format  is  2016030  -> yearweek

required as 201630

please help

[settu_periasamy]

Maybe like this..

=Dual(Left(2016030,4)&right(2016030,2),

     Left(2016030,4)&right(2016030,2))

[#3]

=WeekName(Today())

[Clever_Anjos]

If you have a date field, this should work

=Date(WeekStart(yourdatefield),'YYYYWW')

[qvqfqlik]

Field has a yearweek format Yyyy0ww

This week is like 2016030

I need to convert it as 201630

[Clever_Anjos]

How do you create your yearweeek field?

[qvqfqlik]

This field is coming from SAP and iam reading it in qv

[Clever_Anjos]

Please try

=replace(WeekName(MakeWeekDate(left(yourfield,4),Right(yourfield,2))),'/','')