Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I want to convert my noramal date into fiscal ID.
Suppose i have date 06-APR-05
I wanted to change it into 20050406 and
weekd id --200514
Month ID --200504
QuarterID --20052
etc.
Regards,
KK
stalwar1kush141087sureshqvQlikView Forums & Resources
Hi,
If your date field in date datatype then
try
date(DateField,'YYYYMMDD')
If it not in date datatype then
date(date#(dateField,'YYYY-MMM-DD'),'YYYYMMDD')
go to help menu
see
weekName()
MonthName()
Explore other date function also.
Regards
Hi,
If your date field in date datatype then
try
date(DateField,'YYYYMMDD')
If it not in date datatype then
date(date#(dateField,'YYYY-MMM-DD'),'YYYYMMDD')
go to help menu
see
weekName()
MonthName()
Explore other date function also.
Regards