Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bushpalaamarnat
Creator
Creator

create date field using information

Hi all,

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

 

Week
W30-18
1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

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')

View solution in original post

5 Replies
Anil_Babu_Samineni

Not really sure your intend, Perhaps this?

Load DateField,

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

From Table;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bushpalaamarnat
Creator
Creator
Author

getting error no date feild

sergio0592
Specialist III
Specialist III

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
Contributor III
Contributor III

Its Correct

pintucs20
Contributor III
Contributor III

Hi Great