Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1. how to convert date from string formt?
Date#(DateField,'D/M/YYYY')
Change 'D/M/YYYY' to format of your date field
Hi Manoj,
Try like this
=Date(Date#(YourDateDimension, 'Source Date Format'), 'Target Date Format')
Example:
=Date(Date#('2014-05-29', 'YYYY-MM-DD'), 'DD-MM-YYYY') Now the result is : 29-05-2014
=TimeStamp(TimeStamp#('2014-05-29 14:30:30', 'YYYY-MM-DD hh:mm:ss'), 'DD-MM-YYYY hh:mm:ss') Now the result is : 29-05-2014 14:30:30
Regards,
Jagan.