Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
Iahve a date field with data as" Apr 9 2014 12:00AM". I need help iin converting it into "09-04-2014"
Thanks in advance!!
Date(myFieldDate)
Use Floor(), like:
Load
Date(Floor(YourField)) as Date
LOAD
date(floor(YourDateField),'DD-MM-YYYY') as YourDate
HTH
Andrei
Try with below scripts
Date(Date(YourDateField,'MMM D YYYY hh:mm TT'),'DD-MM-YYYY')
Or
Date(Date#(YourDateField,'MMM D YYYY hh:mm TT'),'DD-MM-YYYY')
Or
Date(YourDateField,'DD-MM-YYYY')
Hi,
Try like this
LOAD
*,
Date(Date#(DateDimensionName, 'MMM D YYYY hh:mmTT'), 'DD-MM-YYYY')
FROM DataSource;
Replace DateDimensionName with your date dimension name.
Regards,
Jagan.