Week.Year format

[#1]

hi All,

How we can find weeknumber.YYYY from this date format  MM/DD/YYY.

tHANKS

[amit_saini]

Try this:

week(Date_Field,'MM/DD/YYY') as weeknumber

Thanks,

AS

[#3]

week(date)

Week number. Returns an integer representing the week when the fraction of expr is interpreted as a date according to the standard number interpretation.

[PrashantSangle]

Hi,

Write

Week(Date#(Date_Field,'MM/DD/YYY'))

Regards

[amit_saini]

Also try this:

week(Datefield) & ' / ' & year(Datefield) as Week,

and for weekday:

    weekday(Datefield) as Weekday

Thanks,
AS

[aveeeeeee7en]

Hi

Use this:

week(YourDateField)&'.'&Year(YourDateField) in your Script and after reload use this field in your Front end.

See the Snapshot:

Also, see the Attachment.

Regards

Av7eN