To get week no with prefix 0 for weekno

[anmita]

Hello Everyone,

How can we get the week no using this format

startDate = New DateTime(2023,01,29)
targetDate = New DateTime(2023,02,05)
((CInt(Math.Floor((targetDate-startDate.AddDays(CInt(-1*startDate.DayOfWeek))).TotalDays)) \7-1)).ToString

So it returns 1 currently

How can we get it as 01

So that for all Week no between 1 to 9 it should prefix 0

[ppr (Peter)]

Filling up with 0 we would do for strings like:

[anmita]

Hi @ppr this approach will add for all 0

How can we define the condition that only till week 9 its prefixed not for all of them

[ppr (Peter)]

@anmita

this approach will add for all 0

it will fill up when needed

[Gokul001 (Gokul Balaji)]

Hi @anmita

How about this expression

If(((CInt(Math.Floor((targetDate-startDate.AddDays(CInt(-1*startDate.DayOfWeek))).TotalDays)) \7)+1).ToString.Count=1,"0"+CStr((CInt(Math.Floor((targetDate-startDate.AddDays(CInt(-1*startDate.DayOfWeek))).TotalDays)) \7)+1),CStr((CInt(Math.Floor((targetDate-startDate.AddDays(CInt(-1*startDate.DayOfWeek))).TotalDays)) \7)+1))

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

Hello @anmita
Just try by adding (“D2”) in your expression

@anmita

((CInt(Math.Floor((targetDate-startDate.AddDays(CInt(-1*startDate.DayOfWeek))).TotalDays)) \7-1)).ToString

((CInt(Math.Floor((targetDate-startDate.AddDays(CInt(-1*startDate.DayOfWeek))).TotalDays)) \7-1)).ToString("D2")

[postwick (Paul)]

Make the end…

.ToString(“D2”)

Standard numeric format strings

[anmita]

Hi @Gokul_Jayakumar

Thanks for approach

Can you let me know if for 11 will it be shown as 011 because that would be incorrect

[anmita]

Thanks @Gokul001

[Gokul_Jayakumar (Gokul Jai)]

@anmita
Check this

[anmita]

Thanks @Gokul_Jayakumar

[anmita]

Thanks @postwick