Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have various date format like INVC_DT =DD-MM-YYYY
HIRE_DT=MM/DD/YYYY
BL_BT_DT=MM.YYYY.DD
AND SO ON................
So I my user want only one date format like DD/MM/YYYY
is there any way to get above format for all
Thanks
Prashant
Hi,
In script convert all dates to single format
LOAD
*,
Date(Date#(INVC_DT, 'DD-MM-YYYY'), 'DD/MM/YYYY') AS INVC_DT_FORMATTED,
Date(Date#(HIRE_DT, 'MM/DD/YYYY'), 'DD/MM/YYYY') AS HIRE_DT,_FOMATTED,
Date(Date#(BL_BT_DT, 'MM.YYYY.DD'), 'DD/MM/YYYY') AS BL_BT_DT_FORMATTED
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
Sample Script:
FinalTable:
Load
MyDateField
,DATE(ALT(Date#(MyDateField,’DD/MM/YYYY’)
,Date#(MyDateField,’MMM/DD/YYYY’)
,Date#(MyDateField,’DD/MMM/YYYY’))) AS MyFieldInDateFormat
Resident TablenAME;
Hi,
In script convert all dates to single format
LOAD
*,
Date(Date#(INVC_DT, 'DD-MM-YYYY'), 'DD/MM/YYYY') AS INVC_DT_FORMATTED,
Date(Date#(HIRE_DT, 'MM/DD/YYYY'), 'DD/MM/YYYY') AS HIRE_DT,_FOMATTED,
Date(Date#(BL_BT_DT, 'MM.YYYY.DD'), 'DD/MM/YYYY') AS BL_BT_DT_FORMATTED
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
Hi,
You need to look at alt function in case if it is through 1 field. For multiple fields you can convert then at script as suggested by Jagan.
Which conditional functions do you use?
Regards
ASHFAQ
Thanks Jagan... but I am unable to see Latest QlikView Discussions.
Hi,
I think there is some issue, you can use below link to see latest QV discussions.
Regards,
jagan.