create date field using information

[bushpalaamarnat]

Hi all,

Kindly let me know, how create a date field using this information:

Week

W30-18

[Anil_Babu_Samineni]

Not really sure your intend, Perhaps this?

Load DateField,

         'W' & Week(DateField)&'-'&Num(Year(DateField),'00') as NewField

From Table;

[bushpalaamarnat]

getting error no date feild

[sergio0592 · Accepted solution]

Hi, try with this for fetch a date from your Week field :

=Date(Date#('01/01/'&right(Week,2),'DD/MM/YYYY')+mid(Week,2,2)*7,'DD/MM/YYYY')

[pintucs20]

Its Correct

[pintucs20]

Hi Great