Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
i have a publish date() column.. in that each id have multiple dates. but i need to show up only latest publish date in my table.
how can i get latest date in my table. when i used max(publishdate) am not getting.
please help me out.
Hi,
May be like this:
MaxString(publishdate) or MaxString(Date#(publishdate))
Try in place of Max you use Maxstring(publishdate)
Regards
Anand
Hi,
Create a apply map to get the max date date and add to the main table from the script itself.
Regards,
Sijo
Hi,
try Maxstring(publishdate).
If not post sample data to look over.
Regards
ASHFAQ
What is your PublishDate format?
i.e. DD/MM/YYYY or DD-MM-YYYY or something else?
even above mentioned all r not working.. getting calculation error
MaxString(publishdate) or MaxString(Date#(publishdate))
format is ' DD/MM/YYYY'
Try something like below
=Max(Date(Date#(publishdate,'DD/MM/YYYY')))
HI,
can you post sample data?
Regards
ASHFAQ